2 Replies Latest reply: Apr 24, 2013 2:57 PM by Saranya Dhamodharan

# Average No of Days between two dates in INLINE formula

In a graph, I assigned FIELD1 as Dimension which contains three variable values(See INLINE formule).Basically I am looking for average no.of days between each date fields in formula and set in x-axis.

In Y-axis, I would like to define the maximum number of days like (from 0,5,10,30,50).

So for example the average no of days between [Offered Date]-[Visited Date] is 25 then the graph should be in Y-axis in between 10-30.

and the average no.of days between [Purchased Date]-[Offered Date] is 50 then the graph should be in maximum point in Y-AXIS

and the average no.of days between [Final Date]-[Purchased Date] is 4 then the graph should go down in Y-Axis in between 0-5.

• ###### Re: Average No of Days between two dates in INLINE formula

See attached qvw.

• ###### Re: Average No of Days between two dates in INLINE formula

Excellent!!

Thank You so much. You saved my time.

Choclate time...