Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Since we cannot set default value for app , I'm trying to modify expressions for visualizations to set default value but its throwing error.
pls help!!!
count( distinct {$<if(GetSelectedCount(MonthYear)=0,MonthYear={date(max(MonthYear-1),'MMM-YYYY')}),[Enrollment]={'Enrollment'}>}[IDN_RCPT])
Try this:
If(GetSelectedCount(MonthYear) = 0, Count(DISTINCT {<MonthYear={"$(=Date(AddMonths(Max(MonthYear), -1),'MMM-YYYY')}, [Enrollment]={'Enrollment'}>} [IDN_RCPT]), Count(DISTINCT {<[Enrollment]={'Enrollment'}>} [IDN_RCPT]))
Hi Sunny,
Above expression doesn't work.
Sorry, I missed a double quote, try this:
If(GetSelectedCount(MonthYear) = 0, Count(DISTINCT {<MonthYear={"$(=Date(AddMonths(Max(MonthYear), -1),'MMM-YYYY')"}, [Enrollment]={'Enrollment'}>} [IDN_RCPT]),Count(DISTINCT {<[Enrollment]={'Enrollment'}>} [IDN_RCPT]))
this part of expression is not working
Count(DISTINCT {<MonthYear={"$(=Date(AddMonths(Max(MonthYear), -1),'MMM-YYYY')"}, [Enrollment]={'Enrollment'}>} [Recipient Identifier]))