Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello all
I have the following straight table:
dimension, measure 1, measure 2
I want to show everytime, those rows, when measure 1 and measure 2 are not null .
How do i do that please?
Thank you 🙂
@ioannagr you need to put this expression in Dimension,
aggr(if(measure1 >0 and measure2>0, Dimension),Dimension)
and uncheck "Include null values"
@ioannagr do you have a sample data to see
@ioannagr you can create calculated dimension like below
= aggr(if(measure1 >0 and measure2>0, Dimension),Dimension)
Replace measure 1 & measure 2 with actual expressions of measure 1 & measure 2
@Kushal_Chawda excuse my ignorance, i've never done this before, where do i put this ?
Hi Ioannagr,
In the Dimension tab, you can use the expression given by Kush.
aggr(if(measure1 >0 and measure2>0, Dimension),Dimension)
and "check the suppress when values is Null" checkbox .
Hope it helps
@MayilVahanan hi, i don't have a suppress when values is null, only include null values which i unchecked!
is it okay?
Hi @ioannagr
Can you provide the sample file to understand better or screenshot?
@ioannagr you need to put this expression in Dimension,
aggr(if(measure1 >0 and measure2>0, Dimension),Dimension)
and uncheck "Include null values"
Thank you all, I just gave @Kushal_Chawda the solution because of his speedy answer, but thank you guys lots as well 🙂