Hi all,
I have been trying to find out Set Analysis to show a KPI, Average Records by each month in business days.
The user picks a month and based on that month selection I want to divide the avg by the business days for that month(There could be different business days per month based on the holidays in USA).
This is the expression I am using to get the avg of records for each month. Here "year_month" is date for e.g Mar-2022 with "avg records" = 344.
Count({<Month = {$(=Max(=Aggr(count(DISTINCT RECORD_ID),year_month)))}>} distinct(RECORD_ID))
I have calculated business days for each month separately and my goal is to divide by the business days of the month selected by the user.
Thanks in adavance for the help!
