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

Dynamic %change metric within a freeform table in Workspace

Avatar

Avatar
Validate 1
Level 2
Jeremy_Brugger
Level 2

Likes

5 likes

Total Posts

25 posts

Correct Reply

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

Avatar
Validate 1
Level 2
Jeremy_Brugger
Level 2

Likes

5 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
Jeremy_Brugger
Level 2

25-07-2016

Is it possible to have a dynamic calculated metric in a freeform table? 

Example: A single row dimension (or group of segments) and a single metric with two date ranges I'd like to be able to calculate the % change (similar to how the summary change viz works, but I'd like this displayed as a column within the table for each row).  Ideally the column would work similar to excel where the calculation is defined within the table, that way if Mobile Device Type is changed to Tracking Code, the calculation will stay.

See column in bold below.

 

                                                           
 Visits
Mobile Device TypeLast Week2 Weeks Ago% Change
Other1009011.1%
Mobile Phone908012.5%
Tablet5025100.0%
Media Player330.0%
Gaming Console21100.0%
Set-top Box110.0%
EReader000.0%