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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Date comparision not working

Avatar

Community Advisor

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

Avatar

Correct answer by
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

Avatar

Correct answer by
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

Avatar

Community Advisor
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.