Workspace: Metric Agnostic % change column

Avatar

Avatar
Validate 1
Level 1
tcrewes1
Level 1

Like

1 like

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
tcrewes1
Level 1

Like

1 like

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile
tcrewes1
Level 1

08-01-2021

Hi everyone,

I'd like to know if it is possible to create a "metric agnostic" % change column in workspace. In workspace I have several tables where:

Column A is a list of metrics
Columns B and C are different date ranges

I.e.

MetricsLast MonthThis Month
Metric 1123123
Metric 2123123
Metric 3123123


This helps me quickly see metric performance against different time periods. However at the moment, if I want to add a % change column, I need to export this into excel to do that calculation. I'd like to be able to add an additional column in workspace which shows the % change, regardless of what metrics are included in the table, or what date ranges are used, i.e.

 

MetricsLast MonthThis Month% Change
Metric 1123123xx
Metric 2123123xx
Metric 3123123xx


It appears when the table is in this configuration the "compare time periods" option is not available. And I can't think of a way to do this in a calculated metric.

Does anyone know if what I am after is possible?

Thanks

Toby


Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Affirm 25
Employee
Khurshid_Alam
Employee

Likes

56 likes

Total Posts

198 posts

Correct reply

41 solutions
Top badges earned
Affirm 25
Boost 50
Affirm 10
Boost 25
Affirm 5
View profile

Avatar
Affirm 25
Employee
Khurshid_Alam
Employee

Likes

56 likes

Total Posts

198 posts

Correct reply

41 solutions
Top badges earned
Affirm 25
Boost 50
Affirm 10
Boost 25
Affirm 5
View profile
Khurshid_Alam
Employee

08-01-2021

You may use in built feature to compare data between date ranges. Right Click on the metric > Select Add Time... and then select a time period. Let mw know if that helps.

Khurshid_Alam_1-1610129047060.png

 

 

Khurshid_Alam_0-1610129024954.png