Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

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

Community Advisor

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?

Avatar

Level 1

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