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

Scalable percent change?

Avatar

Avatar
Validate 1
Level 1
evan9
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
evan9
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
evan9
Level 1

10-03-2020

Hello,

 

In Workspace, I am using the percent change column to track YoY changes. I right click on a column and choose the date range I want to compare to, and the percent change column is generated.

 

The percent change column seems to be generated in a way that is hard coded to the two input columns. Is there a way to set up a percent change column that is just attached to the two columns, and is NOT hard coded? It would be much easier to change date ranges and segments if I could do this. Currently if I change date ranges or segments on my columns, the percent change column does not always accurately reflect the change in date range or segment.

 

I know the summary change visualization does this, attaches to 2 cells instead of being hard coded. Can the percent change column do that as well?

 

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
Level 3
mathildeb777400
Level 3

Likes

17 likes

Total Posts

35 posts

Correct Reply

1 solution
Top badges earned
Contributor
Validate 1
Shape 1
Boost 5
Boost 3
View profile

Avatar
Contributor
Level 3
mathildeb777400
Level 3

Likes

17 likes

Total Posts

35 posts

Correct Reply

1 solution
Top badges earned
Contributor
Validate 1
Shape 1
Boost 5
Boost 3
View profile
mathildeb777400
Level 3

11-03-2020

Hi,

 

It is only dynamic if you use rolling dates.

If you click for example on "Prior month to this date range" it won't be hard coded but if you select a specifi period it will be hard coded.

For MoM changes, I created a date range as follows :

Start : start of current month minus 28 days

End : start of current day minus 28 days

 

For YoY, try this :

Start : start of current year minus 1 year

End : start of current day minus 365 days

 

Answers (0)