1 Reply Latest reply: Oct 6, 2011 4:24 PM by alejandro hernández RSS

    Date analyze

      Hello!

       

      I have QV-application with info about Service Desk work.

       

      I need

      1)  table with next fields: "Assignee", "Count of incidents resolved during 1 day", "Count of incidents resolved during 1 week", 1 month, etc.

      2)  additional table with info about percentage.

      3)  table with info about average time of resolving for each of fields

       

      So there are 2 dates for each incident: Reported_time and Resolved_time. And time of resolving process = Resolved_time - Reported_time.

       

      My problem is

      I do not understand how to work correctly with such operation as "Resolved_time - Reported_time" or "if (Resolved_time - Reported_time) >0 and (Resolved_time - Reported_time)<1), count (Incident_ID)" during the loading or how to make it as condition in expression (in table)

       

      For example xls are attached. One is real data I have (Resolved_time is

      [Resolved.TIME]

      - Reported_time is

      [Reported Date+]

      And another is about my tasks.

       

       

      Thanks a lot for your help!