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

SOLVED

Date comparision not working

David-123
Level 7
Level 7

Hi All,

 

Please can someone let me know what I am doing wrong here or if this is bug?

 

I am trying to do a year on year percentage change using the following technique:

 

1)Simple freeform table with Day and Visits with a timeframe of "Last month" - works fine

2)Right click on Visits and select "This month last year to this date range" - again works fine

David-123_0-1610468202894.png

 

3)At this point no comparison column is added - however I can select all the metrics at the top, right click "Create metrics from selection" and select "Percentage Change".

David-123_1-1610468479262.png

4)This then adds in every day for the last year which has a mixture of the following:

December 2019 = -100%

Jan - November 2020 = 0%

December 2020 = Infinity%

David-123_2-1610468673370.png

 

Does anybody have any idea what is going on here? This used to work as a one click button.

 

Thanks


Dave

 

1 Accepted Solution
yuhuisg
Correct answer by
Community Advisor
Community Advisor

I was unable to replicate your step 4's results.

Screenshot 2021-01-13 at 10.50.47 PM 1.png

 

But did you perhaps intend to use the "Compare time periods" right-click-menu item instead?

Screenshot 2021-01-13 at 10.52.33 PM.png

View solution in original post

2 Replies
yuhuisg
Correct answer by
Community Advisor
Community Advisor

I was unable to replicate your step 4's results.

Screenshot 2021-01-13 at 10.50.47 PM 1.png

 

But did you perhaps intend to use the "Compare time periods" right-click-menu item instead?

Screenshot 2021-01-13 at 10.52.33 PM.png

View solution in original post

David-123
Level 7
Level 7
I heard back from Adobe on this today. The reason I am having an issue is because my dimension was a date. It works fine wt. an eVar.