Expand my Community achievements bar.

Join us for our next community Coffee Break on February 28th! Four of our Analytics Champions will be joining us to discuss Summit tips, best practices, and any of your Analytics questions!

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.