calculated dimension

[Anonymous]

Hi

I need to create a calculated dimension for a chart which disregards the current selection in the Field 'Wave'.

I try: =Aggr(Only({<Wave=>}Wave), Wave)

But it doesn't work. It does not disregard the current selection in the Field 'Wave'.

Could you, please, give me a prompt?

Thank you in advance,

Larisa

[sunny_talwar · Accepted solution]

I think instead of adding it to your dimension, I would add this to all my expressions:

{<Wave=>}

[Anonymous]

It's a nice idea. But the Expressions (there are 20 different ones which get activated on a certain condition) are based on Variables which I don't want to change.

So, is it possible to set a calculated dimension?

[rwunderlich]

Aggr(Only(1}Wave), Wave)

It will still get filtered by the Expressions, so may not give you what you expect.

-Rob

[satishkurra]

Correcting Rob's expression.

Just a type

Aggr(Only({1}Wave), Wave)

Rob: Apologies if anything wrong...

Thanks

Satish

[Anonymous]

Thanks, everyone, for your comments!