Month Over Month not working on First Day of the Month | Community
Skip to main content
K
Kai77
New Member
February 9, 2023
Solved

Month Over Month not working on First Day of the Month

  • February 9, 2023
  • 1 reply
  • 652 views

I have reports that need to be sent out daily comparing current MTD vs previous MTD. For example, if today is Mar 9, it'll be comparing Mar 1-9 data to Feb 1-9 data. But this breaks on the first day of each month. On Mar 1, Adobe is trying to compare Mar 1-1 vs Feb 1-1, but it returns 0 for the metrics on Mar 1 resulting in any % change or difference to be wrong. I'd like Adobe to use Feb vs Jan data on the day of Mar 1.

 

The solution logic can be a simple if statement, but it's hard to code that directly into Adobe. Does anyone have a workaround for this MTD vs PMTD issue on the first day of each month?

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

I don't think this is currently possible in Workspace... you can do something like that using Report Builder and Excel... you can create formulas to calculate the date range based on "today()" and some if statements to dynamically calculate the to and from date ranges for your "current" and "previous" time frames.

 

Then you use those cells to drive the start/end dates in Report Builder, pull in your data and then present the data all in Excel; you can even schedule this to send out automatically every day.

 

 

I did something similar to this with a monthly report that looked at YTD. When the report runs on Jan 1, instead of looking at this year... I look at the full last year and previous year. Then in Feb, it calculates the YTD and Previous YTD (ie. Jan this year vs Jan last year)

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
February 10, 2023

I don't think this is currently possible in Workspace... you can do something like that using Report Builder and Excel... you can create formulas to calculate the date range based on "today()" and some if statements to dynamically calculate the to and from date ranges for your "current" and "previous" time frames.

 

Then you use those cells to drive the start/end dates in Report Builder, pull in your data and then present the data all in Excel; you can even schedule this to send out automatically every day.

 

 

I did something similar to this with a monthly report that looked at YTD. When the report runs on Jan 1, instead of looking at this year... I look at the full last year and previous year. Then in Feb, it calculates the YTD and Previous YTD (ie. Jan this year vs Jan last year)

    Terms & ConditionsAccessibility statement

    Loading footer...