topic Re: Sum with aggr and count in expression in App Development

Sum with aggr and count in expression

qwerty89 — Thu, 04 Apr 2019 11:01:21 GMT

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))

Re: Sum with aggr and count in expression

sunny_talwar — Thu, 04 Apr 2019 12:40:17 GMT

Try this

Sum({<provider_id>} Aggr(
  Count(DISTINCT {<provider_id, service_status = {'closed'}, service_type = {'regular'}>} key)
, customer_id, provider_id))

Re: Sum with aggr and count in expression

qwerty89 — Thu, 04 Apr 2019 13:13:16 GMT

Thanks!!