Report column date wont update automatically | Community
Skip to main content
March 24, 2021
Solved

Report column date wont update automatically

  • March 24, 2021
  • 2 replies
  • 1462 views

Hi, i have been trying to automate a clients SEO report but i am facing an issue with the table.

 

So on the top right corner the date has been set to last month:

 

And on the columns i am comparing visits to by clicking on the column and selecting "Compare time periods" > "This month last year to this date range" which now compared Feb 2021 vs Feb 2020 when the next month comes the top right corner date rolls over and updates. However, the date on the table seems to remain static and not update so next month i will end up having March 2021 vs Feb 2020.

 

I hope my explanation is clear, do you know why it might now update?

 

Thank you

Xhoi

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 akt0m3r

Hi @xhoi

That seems to be an expected behavior while using compare time period. I would recommend you use Custom Date range with "Rolling Dates" feature which gives you the flexibility to comparing the dates as you change the date in free form table or creating a Dashboard which can automatically update the report everyday or every month. Here is a document on the same:

https://experienceleague.adobe.com/docs/analytics/analyze/analysis-workspace/components/calendar-date-ranges/custom-date-ranges.html?lang=en#section_C4109C57CB444BB2A79CC8082BD67294

Hope this helps!

2 replies

akt0m3r
Adobe Employee
akt0m3rAdobe EmployeeAccepted solution
Adobe Employee
March 24, 2021

Hi @xhoi

That seems to be an expected behavior while using compare time period. I would recommend you use Custom Date range with "Rolling Dates" feature which gives you the flexibility to comparing the dates as you change the date in free form table or creating a Dashboard which can automatically update the report everyday or every month. Here is a document on the same:

https://experienceleague.adobe.com/docs/analytics/analyze/analysis-workspace/components/calendar-date-ranges/custom-date-ranges.html?lang=en#section_C4109C57CB444BB2A79CC8082BD67294

Hope this helps!

XhoiAuthor
March 31, 2021
Thanks @akt0m3r this does help but is so complicated to do a YoY on adobe analytics.
yuhuisg
Community Advisor
Community Advisor
March 25, 2021

When you created that component from the contextual menu, Analysis Workspace (unfortunately) uses static dates in the compared date range, instead of relative dates. It's not immediately obvious, and it trips a lot of people up. That's why I said "unfortunately". 😥