Average Time by Distinct Group

[Anonymous]

Hi,

Hopefully this is in the right place, and if anyone can help it would be really appreciated.

I have data similar to the below table.   I want to find the average time taken per distinct order and test group.

Order	Test Group	Order & Test Group	Code	Time Taken
1	A	1A	1	5
1	A	1A	2	5
1	A	1A	3	5
1	B	1B	1	15
2	A	2A	1	10
2	B	2B	1	10
3	A	3A	1	20

So in this example the code columns means that I am getting 3 counts of '1A', but I only want 1, so I want my average to be

(5+15+10+10+20)/5=12, not (5+5+5+15+10+10+20)/7=10.  I basically want to ignore the duplicate 1A Order& Test Groups.

Do you know if this is possible.

Let me know if you would need any extra information.

Thank you,

Neil

[#2]

Hi

[#3]

For getting Total avg, the code is : avg(aggr(avg([time taken]),order,[test group]))