Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use Person as dimension and avg(aggr(sum(Revenue),Date,Person)) as expression.
Hi Humbug
Could you find the attachment hope it helps you
Thanks & regards
Nirmal Raj
Use Person as Diemnsion
and as expression
Aggr(Avg(Revenue),Person)
Use Person as dimension and avg(aggr(sum(Revenue),Date,Person)) as expression.