Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need your help. I have a straight chart with 3 columns and need to filter the data. EX
column 1 column 2 column 3
123456 abcd INDOOR
235466 bbcs OUTDOR
23564 abcd
I want to restrict the data just to be able to see the columns which contain the values INDOOR.
I want to restrict the data only in this specific chart not in the all appreciation.
Could you please suggest what I need to do?
Thank you in advance!
just suppress the null values
I tried to add your code but Enable conditional doesn't works in this case...
Thanks
In dimension tab select the dimension in which u don't want to see the null value and suppress.
Select Dimension
Click on "suppress when value is null " in Dimensions Tab.
Hi all,
I tried all of your advise and I found the following:
add this =only({<[Column 3]={'INDOOR'}>}[Column 3])
- like dimension nothing is changed
- like expression you would see that not only the INDOOR columns, the nulls are too , if you try to suppress zero values or suppress missing noting is changed
Thanks your your help
please share the app
Don't use this in enable condition use this as a dimension.
Add calculated dimension and use this .
Is this you are expecting? If not, You must share exact output need?
your scenario is fine but my data is wrong
My scenario was not working ?