Date comparision not working

Avatar

Avatar

David-123

Avatar

David-123

David-123

12-01-2021

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

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

yuhuisg

MVP

Avatar

yuhuisg

MVP

yuhuisg
MVP

13-01-2021

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

Answers (0)