Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to write an expression in pivot table.
Dimension1: Label
Dimension2: Topper
Expression: Count(ID)
but the expression should need the condition as
If Label='Poppy' and Topper equal to any other value instead of Topper<>'Poppy' then the expression should show count(Id). how can I write the expression.
can anyone suggest me please.
Thanks.
count({< Label = {'Poppy'},Topper -= {'Poppy'} >}ID)
count(if(Label='Poppy' and Topper <> 'Poppy',Id)
count({< Label = {'Poppy'},Topper -= {'Poppy'} >}ID)
count({$< Label = {'Poppy'},Topper -= {'Poppy'} >}ID)
You can achieve this in front end using expression:
count({< Label = {'Poppy'},Topper -= {'Poppy'} >} ID)
Or
you can handle this in back end. Create another field in datamodel: Col1 with definition
if(Label='Poppy' and Topper <> 'Poppy',1,0)
In UI use expression Sum(Col1)
Aggregation is faster as compare to count with set analysis
-Sarvjeet
Thanks.
I have a condition where Label='ert','tyu','iop','pou','rew','ion','Tr' and Topper ='Divi','patch','Copy','po' then the expression should show count(Id). will below expression work for it?
Dimension1: Label
Dimension2: Topper
Expression: Count({<Label={'ert','tyu','iop','pou','rew','ion','Tr'}
,Topper ={'Divi','patch','Copy','po'}>} ID)
try the below thing
Count({<Label={'Poppy'},Topper ={'*'}-{'Poppy'}>} ID)
Thanks.
I have a condition where Label='ert','tyu','iop','pou','rew','ion','Tr' and Topper ='Divi','patch','Copy','po' then the expression should show count(Id). will below expression work for it?
Dimension1: Label
Dimension2: Topper
Expression: Count({<Label={'ert','tyu','iop','pou','rew','ion','Tr'}
,Topper ={'Divi','patch','Copy','po'}>} ID)
IF Your requirement is..
Counting the no.of ID's with Label='ert' 'tyu','iop','pou','rew','ion','Tr' and Topper ='Divi','patch','Copy','po'.
then whatever expression your writing is correct.
Thanks.