Average column

[realpixel]

Hello,

I have a dashboard with following information

[client]     [Date IN]             [Date OUT]          [Delay]

client1     16/03/2013          02/03/2013          14        

client1     08/02/2013          21/01/2013          18

client1     21/01/2013          20/12/2012          32

I need when I select "client1" to have the avarage of the column "Delay".

Someon have an idea how to do the operation?

[alexandros17 · Accepted solution]

Create a chart with client1 as dimension, the expression avg(Delay) should be enough ...