Calculating average per week Set Analysis

[jlampard40]

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.

[rubenmarin · Accepted solution]

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

[jlampard40]

Thanks so much!