How to calculate daily average in a table

[#1]

my table looks like this:

Date,Person,Revenue

2015.01.01,A,100

2015.01.01,A,99

2015.01.01,B,98

2015.01.02,A,87

2015.01.02,B,88

2015.01.03,B,70

I want to get the average of daily total revenue for A and B

The daily sum of revenue is

2015.01.01,A,199

2015.01.01,B,98

2015.01.02,A,87

2015.01.02,B,88

2015.03.03,A,0

2015.01.03,B,70

so the result should look like

Person,DailyAverage

A,95

B,85

how to get the final result in one go?

I am thinking of average(aggr(sum(Revenue),Date)) - but it doesn't work.

[nirmalraj_kj]

Hi Humbug

  Could you find the attachment hope it helps you

Thanks & regards

Nirmal Raj

[robert_mika]

Use Person as Diemnsion

and as expression

Aggr(Avg(Revenue),Person)

[Gysbert_Wassenaar · Accepted solution]

Use Person as dimension and avg(aggr(sum(Revenue),Date,Person)) as expression.