Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think instead of adding it to your dimension, I would add this to all my expressions:
{<Wave=>}
I think instead of adding it to your dimension, I would add this to all my expressions:
{<Wave=>}
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?
Aggr(Only(1}Wave), Wave)
It will still get filtered by the Expressions, so may not give you what you expect.
-Rob
Correcting Rob's expression.
Just a type
Aggr(Only({1}Wave), Wave)
Rob: Apologies if anything wrong...
Thanks
Satish
Thanks, everyone, for your comments!