Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all could you please help me with the expression my expected result in 22 for that dimension.
if(
count(aggr(if((num(count( {<TopBox={'1'},FiscalYear={'2018'}>}SRID)/count( {<FiscalYear={'2018'}>}SRID),'#.00000'))=percent1,Srnumber1),FACILITY,percent1,Srnumber1,QuestionLabel))>1
,min(aggr(if((num(count( {<TopBox={'1'},FiscalYear={'2018'}>}SRID)/count( {<FiscalYear={'2018'}>}SRID),'#.00000'))=percent1,Srnumber1),FACILITY,percent1,Srnumber1,QuestionLabel))
,count(aggr(if((num(count( {<TopBox={'1'},FiscalYear={'2018'}>}SRID)/count( {<FiscalYear={'2018'}>}SRID),'#.00000'))>=percent1,QuestionLabel),FACILITY,percent1,Srnumber1,QuestionLabel))
)
When i am adding the Dollar Expansion in Aggr Expression.
if(
count(aggr(if($(=num(count( {<TopBox={'1'},FiscalYear={'2018'}>}SRID)/count( {<FiscalYear={'2018'}>}SRID),'#.00000'))=percent1,Srnumber1),FACILITY,percent1,Srnumber1,QuestionLabel))>1
,min(aggr(if($(=num(count( {<TopBox={'1'},FiscalYear={'2018'}>}SRID)/count( {<FiscalYear={'2018'}>}SRID),'#.00000'))=percent1,Srnumber1),FACILITY,percent1,Srnumber1,QuestionLabel))
,count(aggr(if($(=num(count( {<TopBox={'1'},FiscalYear={'2018'}>}SRID)/count( {<FiscalYear={'2018'}>}SRID),'#.00000'))>=percent1,QuestionLabel),FACILITY,percent1,Srnumber1,QuestionLabel))
)
And when i am selecting only that Dimension value it displays 22.
Would you be able to share a sample to check this out? Difficult to pin-point the issue by just looking at images and expressions