2 Replies Latest reply: Mar 28, 2017 7:21 AM by Ankit Singh RSS

    Condition based on time between 2 dates in measure

    Ankit Singh

      Hi All,

       

      My requirements is show bar chart based on time difference between 2 dates.

       

      2 dates are RequestDate and AcceptDate. Calculate the time difference between 2 dates. Show count in bar chart accept within 2 hour, between 2 to 4 hour, between 4 to 8 hour, between 8 to 24 hour etc. Please explain what measure expression i've to used display bar chart. Please see the attached for example.Image1.jpg based on request

      Thanks in advance

       

      Regards,

      Ankit Singh