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

Avatar

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

Avatar

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

Avatar

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

Avatar

Employee Advisor

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