Average for Count Data - SPC Chart

MS_UK — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to do SPC Chart and I stuck with Average. I have counted repairs per week and I am trying to calculate total average of repairs per week.

Aa a dimmension I have Week Number

Expression 1 = Count(RepairsID)

Expression 2 =Avg(Aggr(Count(RepairsID), WeekNumberSUNSAT)), the same effect when I type =count(RepairID)/ count( distinct WeekNumberSUNSAT)

Results in table below ( I extracted only 20 weeks for one of the year).

In total for 4 years I have 8155 repairs, so average should be 39.2067 repairs per week, which obviously I didn't get with my expression.

In script under RepairID i have below statement:

AutoNumber(Repair&Date&Case_No) as RepairID

I tried to replicate calculations from:

Could you please advise?

Michael

Re: Average for Count Data - SPC Chart

Arthur_Fong — Thu, 03 Oct 2019 05:03:17 GMT

Do you have a sample app?

MS_UK — Thu, 03 Oct 2019 07:58:42 GMT

Hi All,

Thanks for your help,

I found solution, Expression should be as below:

=Avg(TOTAL Aggr(Count(RepairsID), WeekNumberSUNSAT))

Best Regards

Michal