Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to calculate distinct count of key at customer_id and provider_id level then want a sum of these for all the providers and not just the selected provider.
i am using the following expression here.But apparently {<provider_id=>} before the aggr is not affecting the calculation.It is giving values for the selected provider.
sum({<provider_id=>}aggr(count (distinct(<service_status={'closed'},service_type={'regular'}> )key),customer_id,provider_id))
Try this
Sum({<provider_id>} Aggr(
Count(DISTINCT {<provider_id, service_status = {'closed'}, service_type = {'regular'}>} key)
, customer_id, provider_id))
Try this
Sum({<provider_id>} Aggr(
Count(DISTINCT {<provider_id, service_status = {'closed'}, service_type = {'regular'}>} key)
, customer_id, provider_id))
Thanks!!