This content has been marked as final. Show 2 replies
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.