Solved

Last Month to Date metric not working

Forum|Forum|1 year ago
April 15, 2024
4 replies
1905 views

I have a report that includes the "Last Month to Date" metric. That date range is currently pulling as "Mar 1, 2024 - Feb 29, 2024" and resulting in "zeros".

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Jennifer_Dungan

Yes, as of Friday, Adobe is building comparison date ranges incorrectly. This is a recent bug introduced sometime last Friday.

"Prior month to this date range" is working, "This Month last year to this date range" is not.

When my panel is set to "Last Month" and I use "This Month last year to this date range", the date range gets built as:

This is very much incorrect.

"This month last year" (based off of the panel being "last month", should return Mar 1, 2023 - March 31, 2023.... not Jan 1, 2023 - Dec 31, 2022

Start: "Start of Current Month minus 1 month" doesn't even make sense here, as that should return March, 1, 2024 (not Jan 1, 2023)...

End: "Start of Current month minus 1 year" should return Mar 1, 2023 (not Dec 31, 2022)

It's not just the automatically selected values in the definition that's the issue, the calculation of date ranges is not properly working.

Now, as I mentioned, this range can be fixed by doing:

But it's also possible that depending on the needs, not all date ranges can be properly selected and calculated properly at this time.

BTW, if I were to manually set the date range as Adobe set it, I don't even get the same results.... the Start date now matches the expected calculation, but the end date is still messed up:

Jennifer_Dungan

Community Advisor and Adobe Champion

It sure is....

I was chatting with someone else on Friday when this issue started. They logged a ticket with Client Care, I would hope that Adobe is already working on this... but I suggest logging your own ticket so that you can get up-to-date status of the fix.

Jennifer_Dungan

Community Advisor and Adobe Champion

Oh I should mention, in the meantime (depending on how many reports you have that are broken... not sure if it's impacting only new or old), you should be able to fix the date definitions my manually editing the definitions (still making them rolling), but just using better rules to get what you need....

pradnya_balvir

Community Advisor

Your date range is showing wrong. It should be Mar 1, 2024 to Mar 31, 2024.

Right click on your metrics, Click on add time period, select "prior month to this date range".

Refer attached screenshot:

Jennifer_Dungan

Accepted solution

Community Advisor and Adobe Champion

Yes, as of Friday, Adobe is building comparison date ranges incorrectly. This is a recent bug introduced sometime last Friday.

"Prior month to this date range" is working, "This Month last year to this date range" is not.

When my panel is set to "Last Month" and I use "This Month last year to this date range", the date range gets built as:

This is very much incorrect.

"This month last year" (based off of the panel being "last month", should return Mar 1, 2023 - March 31, 2023.... not Jan 1, 2023 - Dec 31, 2022

Start: "Start of Current Month minus 1 month" doesn't even make sense here, as that should return March, 1, 2024 (not Jan 1, 2023)...

End: "Start of Current month minus 1 year" should return Mar 1, 2023 (not Dec 31, 2022)

It's not just the automatically selected values in the definition that's the issue, the calculation of date ranges is not properly working.

Now, as I mentioned, this range can be fixed by doing:

But it's also possible that depending on the needs, not all date ranges can be properly selected and calculated properly at this time.

BTW, if I were to manually set the date range as Adobe set it, I don't even get the same results.... the Start date now matches the expected calculation, but the end date is still messed up:

MandyGeorge

Community Advisor and Adobe Champion

I'm getting this too! @jennifer_dungan and I were talking about this a couple days ago.

I've put in a bug ticket with support. It was a bit frustrating, they said that "this week 52 weeks ago" is working and asked if that was different than "this week last year." I think I convinced them that this is something that actually does need to be fixed, and they've sent it off to engineering. From what I've seen it isn't impacting previously made date ranges, just newly created ones.

The more tickets we have put in about the issue, the more likely they will get around to fixing it. So if you haven't already, submit a ticket to support for it.

E

EricSt4Author

The problem with the metric appears to be fixed. My report ran fine this morning.

Jennifer_Dungan

Community Advisor and Adobe Champion

That is good news indeed! @ericst4 glad to have helped, and very glad Adobe fixed the issue.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded