Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have this chart
How can i make it so it only shows my members where there is a number all the way?
So those with zeros, should not be shown, it should be like this:
5213731 602,00, 1, 2
only!
You can try to zero columns 2 and 3 where column 1 is not a number:
for your second expression:
=if(isnum(Column(1), ExpressionColumn2)
for your third expression:
=if(isnum(Column(1), ExpressionColumn3)
Then check 'Suppress zero values' on presentation tab.
Is your second column a dimension? If so you can check 'Suppress When Value is Null' for that dimension, else for all the expressions, you have to put conditional appearance(presentation tab).
You can try to zero columns 2 and 3 where column 1 is not a number:
for your second expression:
=if(isnum(Column(1), ExpressionColumn2)
for your third expression:
=if(isnum(Column(1), ExpressionColumn3)
Then check 'Suppress zero values' on presentation tab.
Column, 2,3,4 are expressions.
Only column one is a dimension.
I did this for column 3
If(column2 >=1, sum(column3), null())
same expressions is here
=if(Sum({<Date_Clean={'$(vDynamicDateUser)'}>} AntalBuy) >=1,Sum({<Date_Clean={'$(vDynamicDateUser)'}, EventTypeKey={196}>}AntalBesøg),null())
would this work proper?
Both @tresesco and @swuehl
Try this:
calculated dimension : Aggr(If(Sum({<Date_Clean={'$(vDynamicDateUser)'}>} AntalBuy)>0,YourDimension) ,YourDimension)
Then check 'Suprress When Value is Null' in the dimention tab.
Dear Experts,
I have a question, please help. similar to the above example I have 6 dimensions in the list, I would like to hide only null values, from the 6 dimensions see the below screenshot only last 5 rows , if dimension A has a null value, Dimension B with a value, that should show. can you suggest me something