Editing Percent Change Column

Avatar

Avatar

Nichole_Bohorqu

Avatar

Nichole_Bohorqu

Nichole_Bohorqu

27-11-2017

When comparing a YoY hourly trend and selecting "Row Settings - Date Comparisons: Align dates from each column to all start on the same row (applies to entire table).

I get an infinity%. Unsure of how to fix this.

1359504_pastedImage_0.png

Replies

Avatar

Avatar

PratheepArunRaj

Moderator

Avatar

PratheepArunRaj

Moderator

PratheepArunRaj
Moderator

27-11-2017

Dear Nichole,

Can you click on the information icon of "Percent Change" and see whether the formula is correct as below :

1359607_pastedImage_0.png

If not please edit to use the same. Formula below :

1359701_pastedImage_1.png

Hope this helps.

Thank You!

Arun

Avatar

Avatar

Nichole_Bohorqu

Avatar

Nichole_Bohorqu

Nichole_Bohorqu

28-11-2017

Hi Arun,

That is the formula used.

I'm using the standard "compare time period" functionality when you right click on a metric.

1359994_pastedImage_0.png

Avatar

Avatar

Gigazelle

Employee

Avatar

Gigazelle

Employee

Gigazelle
Employee

19-09-2018

This seems like the metric was having trouble getting the target date range. Is it still an issue?

Avatar

Avatar

ovativec9406854

Avatar

ovativec9406854

ovativec9406854

27-11-2019

I'm having this same issue and I don't see a solution out here.