7 Replies Latest reply on Sep 3, 2018 2:42 PM by Okechukwu Ossai

    How to made a summary table of data (SLA of time)

    Matías Merino

      Hi,

      i need to do a simple table, but for me its impossible.

      I have a data of a workflow, with a lot of "stages", and i need to measure the time for every stage.

      The Unique ID is "N° Solicitudes", the stages are "Actividad" and "IP (Tiempo Total)" is a calculed field that give me the total time of a certain stage, in this case "IP" (That are a 3 stage of the flow).

       

      For Every ID (N° Solicitudes) i need to do if pass a SLA of time (3 days) in the stage (group) "IP"

       

      For Example:

       

      INFSENP000004080 have 5 days of time for the stage "IP", so that ID don't pass the test of SLA.

      INFSENP000004118 have 0 days of time for the stage "Ip", si that ID pass the test of SLA and that is for every ID.

      1.PNG

      So i need to do a table (Resume) that count the next:

      Total N° Solicitud: 34

      Approve SLA: 22

      No Approve SLA:  12

      Untitled-1.jpg

      But if a sum the data, or if i quit the ID "N° Solicitud" only made the test for the row, and no every ID (N° Solicitud).

       

      Thanks for all the test for a newbie in Tableau

       

      Greetings!