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

    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.