topic Re: facing issues in including zero values with set expression in App Development

facing issues in including zero values with set expression

Prachi_Pradip_Kulkarni — Fri, 12 Nov 2021 09:29:47 GMT

In dimension for showing trends of last 6 quarters, last 6 months and last 30 days according to dropdown selections, we have created a expression using pick and match and in measure we have used set analysis...we are getting correct data but for 2 quarters there is no data and we want that zero data as well ....if we use if condition we are getting the required visualization but facing this problem with set analysis

dimension expression: = pick(match('$(vPeriod)','Monthly','Quarterly'','Daily'),RollingMonth,QT,RollingDate)

here vPeriod is variable whose values change according to dropdown selections ('Monthly','Quarterly','Daily') and Rollingmonth field contains last 6 months ,RollingDate field contains last 30 days and QT contains quarters

measure expression: (count(distinct {$<RED_FLAG ={1}>} [AT_PROJECTID] ))

if RED_FLAG=1 we want count of distinct PID's

Kindly provide any solution to include zero data points in chart

Thanks in Advance🙂

Re: facing issues in including zero values with set expression

brunobertels — Fri, 12 Nov 2021 09:52:31 GMT

not sure but may be like this

(

count(distinct {$<RED_FLAG ={1}>} [AT_PROJECTID] )

+0 *

count( {1} distinct {$<RED_FLAG ={1}>} [AT_PROJECTID] )

)

Re: facing issues in including zero values with set expression

Prachi_Pradip_Kulkarni — Fri, 12 Nov 2021 10:18:23 GMT

Hi,

Thanks for reply ... with your solution we are getting data where we are expecting zero data for 2 quarters and getting unexpected high data for other 4 quarters as well

Kindly help!

Re: facing issues in including zero values with set expression

brunobertels — Fri, 12 Nov 2021 10:47:02 GMT

Have you tried to agregate your mesure with aggr() function

(

aggr(count(distinct {$<RED_FLAG ={1}>} [AT_PROJECTID] ),$(vPeriod))

+0 *

aggr(count( {1} distinct {$<RED_FLAG ={1}>} [AT_PROJECTID] ),$(vPeriod))

)

Re: facing issues in including zero values with set expression

Prachi_Pradip_Kulkarni — Fri, 12 Nov 2021 11:53:06 GMT

Hi @brunobertels ,

Thank You for your reply

It isn't worked for me but I found one solution for this

(count(distinct {$<RED_FLAG={1}>} [AT_PROJECTID] )) + Count(DISTINCT [AT_PROJECTID])*0