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?
Solved! Go to Solution.
Views
Replies
Total Likes
@DipikaSomvanshi , Because you have selected only this year Visits metric.
Can you please select Visits from both column and then right click.
Views
Replies
Total Likes
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.
For percent change number, you can select the rows. - > Right click - > Visualize - > Summary change.
You can use this for your manual creation report.
Thanks for your reply. Can I able to create any custom metric like YoY Percentage Change for each month in this case?
Views
Replies
Total Likes
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
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?
Views
Replies
Total Likes
@DipikaSomvanshi , Because you have selected only this year Visits metric.
Can you please select Visits from both column and then right click.
Views
Replies
Total Likes
oh, ok. Sorry, my bad.
Views
Replies
Total Likes
Views
Likes
Replies