Workspace: Metric Agnostic % change column

[tcrewes1]

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.

Metrics	Last Month	This Month
Metric 1	123	123
Metric 2	123	123
Metric 3	123	123

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.

Metrics	Last Month	This Month	% Change
Metric 1	123	123	xx
Metric 2	123	123	xx
Metric 3	123	123	xx

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

[Khurshid_Alam]

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.

[yuhuisg]

@tcrewes1 this solution probably isn't exactly what you want, e.g. where the % difference column operates on whatever metric you have in your table. But at least you don't need to export your table to Excel to calculate the difference manually.