Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Could someone please help me to combine the below specified functions into a one.
I got a function with "COUNT" as, "=Count({<PASID={'*'}>}UNIQUE_SCHEDULES)"
Also I want to filter the above data using a flag which is, "FLAG_Prof_Carer_Type".
I tried as , "Count(IF(FLAG_Prof_Carer_Type=1,Count({<PASID={'*'}>}UNIQUE_SCHEDULES)))" but it is not giving me the results,
Note
field "UNIQUE_SCHEDULES" is a combined field use to filter unique set of data rows. Also, I am using the combined function in a Gauge to represent a percentage.
Appreciate your valuable feedback.
Kind regards,
Andy