topic average of Count (distinct IncidentID) in App Development

average of Count (distinct IncidentID)

Raju_6952 — Tue, 20 Feb 2024 05:57:46 GMT

Hi,

I am calculating the incidents count for last 6 days and need average of that count. Using below mentioned expression for the same but not working...

Avg({<Incident_Date={">=$(=Date(Today()-8))<=$(=Date(Today()-2))"}>} Aggr(Count(DISTINCT IncidentID), IncidentID))

any suggestions?

Re: average of Count (distinct IncidentID)

BrunPierre — Tue, 20 Feb 2024 06:42:41 GMT

Try

=Avg(Aggr(Count(DISTINCT {<Incident_Date={">=$(=Date(Today(1)-6))<=$(=Date(Today(1)))"}>}IncidentID), IncidentID))

Re: average of Count (distinct IncidentID)

Anil_Babu_Samineni — Tue, 20 Feb 2024 06:55:18 GMT

I would rather do this, Today() is not accurate.

=Avg(Aggr(Count(DISTINCT {<Incident_Date={">=$(=Date(Max(Incident_Date)-6))<=$(=Date(Max(Incident_Date)))"}>}IncidentID), IncidentID))

In few case, The same filter need to apply outer analysis as well like,

=Avg({<Incident_Date={">=$(=Date(Max(Incident_Date)-6))<=$(=Date(Max(Incident_Date)))"}>} Aggr(Count(DISTINCT {<Incident_Date={">=$(=Date(Max(Incident_Date)-6))<=$(=Date(Max(Incident_Date)))"}>} IncidentID), IncidentID))