Using today () within a grouping set analysis

jlampard40 — Wed, 22 Dec 2021 16:36:32 GMT

Hi guys - I have the following set analysis, which are now working well thanks to Sunny!

=Count({<[WBR_Stat_Date] = {"$(=Date(Today()))"}>} [WBR_Event_Key]) - for calculating number of clients currently waiting

=Num(Median({$<[WBR_Stat_Date]={"$(=Date(Today(),'DD/MM/YYYY'))"}>} RangeSum([WBR_Event_Date], -[WBR_Clock_Reset_Date])),'#,###') - for calculating the median number of days clients have been waiting for, as of today's report date

I now have the following formula:

=Num(Count(if([WBR_Event_Date]-[WBR_Clock_Reset_Date]<=14,'0-14 days'))/
Count([WBR_Event_Key]),'#.#%')

This needs to calculate the % of clients who are seen within 14 days based on the [WBR_Event_Date]-[WBR_Clock_Reset_Date] part of the formula - but I need this to only show the % as of today's report date. So, again using the function today() to isolate my calculation to just today's report!

Appreciate all your help!

Rgds

topic Using today () within a grouping set analysis in App Development

Using today () within a grouping set analysis