Expand my Community achievements bar.

Join us January 15th for an AMA with Champion Achaia Walton, who will be talking about her article on Event-Based Reporting and Measuring Content Groups!
SOLVED

Why don't I get compare time periods functionality for Time dimension?

Avatar

Level 2

I am trying to create a freeform table where I want month wise visits level data for last 2 years and want YoY Percentage change in number of visits and Month on percentage change from Jan to Dec, How can I do that? Why am I not able to Compare time periods option when I take Month or any Time Dimensions in my freeform table? 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@DipikaSomvanshi , Because you have selected only this year Visits metric.

 

Can you please select Visits from both column and then right click.

 

 

View solution in original post

6 Replies

Avatar

Community Advisor

Hi @DipikaSomvanshi ,

 

Yes, compare time period option is not visible for Time dimension report and visible for other dimensions.

 

In this case you can add visits report for specific year then click on add time period column -> Prior year to this date range. 

Use bar chart for performance visualisation. 

prads_0-1716559661783.png

 

For percent change number, you can select the rows. - > Right click - > Visualize - > Summary change.

You can use this for your manual creation report.

prads_1-1716559861989.png

 

Avatar

Level 2

Thanks for your reply. Can I able to create any custom metric like YoY Percentage Change for each month in this case?

Avatar

Community Advisor

Summary change report is best way to calculate the % of change for month. You need to manually select each month and observe and note the change value.

 

Also, you can try quick calculated metrics in analysis workspace

Select both visit metrics -> right click on it -> Click metric from selection -> click on percent change

 

prads_0-1716902673407.png

https://experienceleague.adobe.com/en/docs/analytics-learn/tutorials/components/calculated-metrics/q...

 

Avatar

Level 2

Thanks a lot for response.

I am not getting Percentage Change option in my workspace. Please check screenshot below. What could be possible reason for this?

DipikaSomvanshi_0-1716912609814.png

 

Avatar

Correct answer by
Community Advisor

@DipikaSomvanshi , Because you have selected only this year Visits metric.

 

Can you please select Visits from both column and then right click.