2 Replies Latest reply on Jul 19, 2019 2:57 AM by Jesus Resendiz

    Resumen in same row Smart Reporting

    Jesus Resendiz
      Share This:

      Hello.

      I need create a report in smart reporting.

      I have a detail for status changed.

      With the next columns (Incident number, Start date/time, Stop date/time, Assigned Group, Status, and Time in status.

      I have one record for status changed.

      Now I need create a report with summary with total time in every status. For example with the previous data, Sum time when Status = Assigned,

           

      Incident Number

      Time assigned

      Time In progress

      Time Pendign

      Time Resolved

      INC000000001249

      444

      44

      1,205,747

      27

       

         Actually I’m creating a report in Smart Reporting but when I sum this times they create new row for every sum for the same incident.

      My formula is next, I change the status for every column:

      Do you know any option to obtain this result in the same row?