1 Reply Latest reply: Oct 6, 2017 1:52 PM by Frank Hartmann RSS

    Count

    Sweeyan Sy

      Data Source For Example:

       

      Created DateResolved DateNoOfMinutes
      15/08/2017 17:3715/08/2017 18:0932
      11/08/2017 15:0411/08/2017 15:4137
      08/08/2017 11:4711/08/2017 21:20573
      11/08/2017 12:3006/09/2017 15:1537704

       

      How do i count the created date in bar chart?

       

      Conditional

      <= 45 Minutes

      > 45 Minutes

       

      Count Based on Created Date and Resolved Month.

      I am using alternate state so that when i click on a month it will display accordingly

       

      The result will be like this:

      i.png

      Created (August)

      <= 45 Minutes = 2

      > 45 Minutes = 2

       

      Resolved (August)

      <= 45 Minutes = 2

      > 45 Minutes = 1