How to find the Average Interval between Days?

[mohan_1105]

Hi,

I wanted to calculate the average interval days between consecutive dates. I found the interval using the following expression,

Interval(Below(date(ORDERDATE)) - date(ORDERDATE),'d')

I tried using the following expression, Aggr(Avg(Interval(Below(date(ORDERDATE)) - date(ORDERDATE),'d')))

it throws me an error in expression saying Below function is not allowed inside aggregation.

I am actually trying to get the table like,

I have attached the sample file for your convenience.

Thanks in advance!!

[tresesco · Accepted solution]

Try like:

Avg(total <Group> Aggr(

Interval(Below(ORDERDATE)-ORDERDATE-1,'D')

,Group,ORDERDATE))

[mohan_1105]

Hi Tresesco,

Thanks for helping me with the expression. It works for good.