How to get chart calculated dimension value into another expression/dimension?

[boryspower]

Hello,

My question is how could I get a value of previously calculated "calculated dimension" to another calculated dimension or expression?

Please look at attached example - I calculate expr1, and I want to use that value in expr2. How to do it?

Ps. Column D could be also an chart expression (ordinary expression, not dimension...)

[sparur]

Hello, Boris.

It's simple:

expression1: Label = age, expression = max(age) (for example)

expression2: Label = age2, expression = [age] * 2 (use label of previous expression)

expression3: Label = age3, expression = [age2] + [age]

[boryspower]

Hi,

Your way works, but only when talking about normal expression - it don't work with Calculated Dimensions...

[sparur]

what columns you put in Calc. dimension?

in you example I don't see any calc dims

[boryspower]

Sorry - maybe I was not clear about it..

Column A is a normal dimension, columns B and C are calculated dimensions, and column D is a normal expression...

[sparur]

Can you move columns B and C into expressions? 🙂

Calculated dimensions are not good approach, it works very slow if you have many rows in charts. Expressions more quickly.

[#7]

Hi, I have a similar issue where I have a calculated dimension where I need to use the value in an expression. Is there a way to use this value in my expression? Please note that my chart does not work when I use the calculated dimension as an expression as it is an aggregated calculation.

Thanks for any help you can provide!

[#8]

Hi,

I have the same problem as Kristy someone knows how to fix this?

[#9]

in case like your, better use expression, like says Anatoly, just try...

I think it's best solution...

[#10]

the problem with expressions is when i use the code, i use as calculated dimension it will not show 2 thesame records. i have the following:
- NAME: dimension
- Start: calculated dimension
- End: expression

sometimes a name as multiple start dates when i use Start as expression it only will show 1 record