Calculated Dimension

sanjujeeboy · ‎2019-03-12

i have created a calculated dimension;

if(abcd<>'Total',abcd)

In front end, if i select a particular value from this dimension abcd, it will show in current selections as

if(abcd<>'Total',abcd)

how to resolve this issue?

Mauritz_SA · ‎2019-03-12

Hi there Sanju

Do you have access to the load script? Then you can use something like this:

LOAD

*,

if(abcd<>'Total',abcd) AS TestField

FROM ...

After this you can add TestField as a dimension and when you make a selection, it will show TestField (or whatever you call it) in the selection bar.

Not sure how you can do it in the front end though.

Hope this helps.

Mauritz

Patrik_Lundblad · ‎2019-03-12

Hi Sanju,

You can create a dimension in the asset panel with that expression and use it in your chart. Check my example at

Regards,

Patrik.

Related Topics