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

Editing Percent Change Column

Nichole_Bohorqu
Level 1
Level 1

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

4 Replies
PratheepArunRaj
Moderator
Moderator

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

Nichole_Bohorqu
Level 1
Level 1

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

Gigazelle
Employee
Employee

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

JohannesDeSilentio
Level 1
Level 1

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