average of Count (distinct IncidentID)

[Raju_6952]

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?

[BrunPierre]

Try

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

[Anil_Babu_Samineni]

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