Calculated Dimensions | Community
Skip to main content
Nick_Potter
Nick_Potter
Level 2
March 2, 2020
New

Calculated Dimensions

  • March 2, 2020
  • 4 replies
  • 3129 views

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!

    4 replies

    J
    JLJ971
    February 1, 2022

    Hi there, very relevant comment, thank you. May you let us know if you found a way to do so, specifically #2?

    FrederikWerner
    Community Advisor and Adobe Champion
    FrederikWernerCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    April 8, 2022

    Just to add some possible approaches:

    Learn more about Adobe Analytics and Customer Journey Analytics on my blogNeed help with Adobe Analytics or Customer Journey Analytics? Let's talk!
    Nick_Potter
    Nick_PotterAuthor
    Level 2
    April 8, 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

    E
    EricSt3
    January 16, 2024

    Or something like REGEXP_EXTRACT.  Also complex nested logical statements is something used very often in the creation of custom channels for traffic.

    This is a fairly typical requirement of most semi-advanced web analytics, but I imagine Adobe is avoiding it to not bear compute costs for users.

    Terms & ConditionsAccessibility statement

    Loading footer...