Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Average No of Days between two dates in INLINE formula

Please find the attached file.

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.

Please help what I am doing wrong here in the below qvw file.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable
Author

Excellent!!

Thank You so much. You saved my time.

Choclate time...