Average Count of Repairs

[kelly_oakley]

Hi all,

I am trying to work out the average count of our repairs

count({$<CalendarYearNo_CompletedDate={">=2016"},CalendarYearNo_CompletedDate={"<2999"},JobCategory-={"Total Loss"}>} JobClaimNumber)

this is the original expression I have, I need to change it to average. I have put in Avg(aggr(count etc and it just gives me blank return.

Any thoughts? Thanks in advance

[lanlizgu]

average of count of repairs by day?

Why don't you divide by the number of days?

[kelly_oakley]

Hi,

It depends on what filters are chosen as to how many days our people are looking at. I am so new to all of this I truly have no idea what would be the best way to do it

[kelly_oakley]

 have changed it to this but still not getting any value return

=avg(aggr(count(JobClaimNumber),JobCategory-={"Total Loss"},{$<CalendarYearNo_CompletedDate={">=2016"},CalendarYearNo_CompletedDate={"<2999"}))