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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Calculated Dimensions

Avatar

Level 2

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

Level 7

08-04-2022

Just to add some possible approaches:

Avatar

Level 2

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