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
BedrockMission!

Learn More

View all

Sign in to view all badges

Editing Percent Change Column

Avatar

Avatar
Boost 1
Level 1
Nichole_Bohorqu
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
Nichole_Bohorqu
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
Nichole_Bohorqu
Level 1

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
Affirm 250
Moderator
PratheepArunRaj
Moderator

Likes

292 likes

Total Posts

831 posts

Correct Reply

252 solutions
Top badges earned
Affirm 250
Contributor
Springboard
Shape 1
Validate 10
View profile

Avatar
Affirm 250
Moderator
PratheepArunRaj
Moderator

Likes

292 likes

Total Posts

831 posts

Correct Reply

252 solutions
Top badges earned
Affirm 250
Contributor
Springboard
Shape 1
Validate 10
View profile
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
Boost 1
Level 1
Nichole_Bohorqu
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
Nichole_Bohorqu
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
Nichole_Bohorqu
Level 1

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
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
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
Give Back
Level 1
JohannesDeSilentio
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Boost 1
View profile

Avatar
Give Back
Level 1
JohannesDeSilentio
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Boost 1
View profile
JohannesDeSilentio
Level 1

27-11-2019

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