count number of days over a specifies value

[SaraKK]

Looking af calls over a specified data range. I want to see how many days we have answered over 20 calls.

But it ignores my "answered_contact_qty= {"=count(answered_contact_qty)>= 20"}" - All others work

count({<date =,queue = {'xxx'}, date.autoCalendar.Year = {'2023','2024'}, subarea = {'xxx'}, answered_contact_qty= {"=count(answered_contact_qty)>= 20"}, [date.autoCalendar.YearMonth] -= {'2023-Jan','2023-Feb','2023-Mar','2023-Apr','2023-May','2023-Jun','2023-Jul','2023-Aug','2023-Sep','2023-Oct'}>} distinct date)

[steeefan]

You need to use dollar expansion on that: answered_contact_qty= {"$(=count(answered_contact_qty)>= 20)"}

[Chanty4u]

Try this 

Sum({<date =, queue = {'xxx'}, date.autoCalendar.Year = {'2023','2024'}, subarea = {'xxx'}, answered_contact_qty = {"=count({<date =, queue = {'xxx'}, date.autoCalendar.Year = {'2023','2024'}, subarea = {'xxx'}>} answered_contact_qty)>= 20"}, [date.autoCalendar.YearMonth] -= {'2023-Jan','2023-Feb','2023-Mar','2023-Apr','2023-May','2023-Jun','2023-Jul','2023-Aug','2023-Sep','2023-Oct'}>} distinct date)