Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I have set analysis which calculates how many clients are currently waiting, based on today's date:
=Count({<[WBR_Stat_Date] = {"$(=Date(Today()))"}>} [WBR_Event_Key])
This works great! However, what set analysis do I need to use to calculate the average number of clients waiting since records began in my company (3 months ago!) The field [WBR_Stat_Date] is what signifies the date of each stat. Many thanks.
Hi, maybe with?
=Count([WBR_Event_Key])/Count(Distinct [WBR_Stat_Date])
// Counting all WBR_Event_Key (is this what says that clients are waiting?) divided by different dates
or:
=Count([WBR_Event_Key])/(Max([WBR_Stat_Date])-Min([WBR_Stat_Date]))
This version counts all days between the lower and higher dates
Hi, maybe with?
=Count([WBR_Event_Key])/Count(Distinct [WBR_Stat_Date])
// Counting all WBR_Event_Key (is this what says that clients are waiting?) divided by different dates
or:
=Count([WBR_Event_Key])/(Max([WBR_Stat_Date])-Min([WBR_Stat_Date]))
This version counts all days between the lower and higher dates
Thanks so much!