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 Type | Last Week | 2 Weeks Ago | % Change |
Other | 100 | 90 | 11.1% |
Mobile Phone | 90 | 80 | 12.5% |
Tablet | 50 | 25 | 100.0% |
Media Player | 3 | 3 | 0.0% |
Gaming Console | 2 | 1 | 100.0% |
Set-top Box | 1 | 1 | 0.0% |
EReader | 0 | 0 | 0.0% |