Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Report column date wont update automatically

Avatar

Avatar
Level 1
Xhoi
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Xhoi
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
Xhoi
Level 1

24-03-2021

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:

Xhoi_0-1616576978931.png

 

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

Automate reporting

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Publish 1
MVP
yuhuisg
MVP

Likes

180 likes

Total Posts

541 posts

Correct Reply

106 solutions
Top badges earned
Publish 1
Affirm 100
Springboard
Bedrock
Validate 1
View profile

Avatar
Publish 1
MVP
yuhuisg
MVP

Likes

180 likes

Total Posts

541 posts

Correct Reply

106 solutions
Top badges earned
Publish 1
Affirm 100
Springboard
Bedrock
Validate 1
View profile
yuhuisg
MVP

25-03-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". 😥

Avatar

Avatar
Establish
Level 2
akt0m3r
Level 2

Likes

8 likes

Total Posts

28 posts

Correct Reply

4 solutions
Top badges earned
Establish
Boost 5
Boost 3
Boost 1
Affirm 3
View profile

Avatar
Establish
Level 2
akt0m3r
Level 2

Likes

8 likes

Total Posts

28 posts

Correct Reply

4 solutions
Top badges earned
Establish
Boost 5
Boost 3
Boost 1
Affirm 3
View profile
akt0m3r
Level 2

24-03-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-dat...

Hope this helps!