Expand my Community achievements bar.

Adobe Analytics Champions applications are now OPEN! Applications are open through June 2nd. Click the link to learn more and apply.

Calculated Dimensions

Avatar

Level 3

02-03-2020

As an analyst I'd like to be able to create "calculated" dimensions. I see this working in 3 ways:

  1. Simple manipulation of a value - for example like the LEFT/RIGHT/MID functions you have in Excel so I can snip out the relevant bit from a dimension value that I need in my workspace report.
  2. Ability to combine two (or more dimension) to create a new one
  3. The functionality to use a CASE statement (or similar) to change the dimension value.

I appreciate something like 3 could be done by classification but the ability to do #1 and #2 at report run-time by the analyst building the report would be great!

3 Comments

Avatar

Community Advisor

08-04-2022

Just to add some possible approaches:

Avatar

Level 3

08-04-2022

@FrederikWerner I don't disagree but not all users have access to that. Including functions to manipulate dimension values at report-time would help regular analysts rather than those with more of the admin access.
Functions I see being useful would be: LEFT/RIGHT/MID/SPLIT/JOIN (for aggregating multiple dimension)/UPPER/LOWER/PROPER

page footer