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)

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.

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

Total N° Solicitud: 34

Approve SLA: 22

No Approve SLA:  12

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!

• ###### 1. Re: How to made a summary table of data (SLA of time)

Hi ,

When do you get these numbers? How are you calculating them

Approve SLA: 22

No Approve SLA:  12

• ###### 2. Re: How to made a summary table of data (SLA of time)

Hi Nitin,

i just count it manually (i can't get that result with count or countd, or other way)

Greeetings,

MM

• ###### 3. Re: How to made a summary table of data (SLA of time)

Hello Matias,

But how are you counting them . whats the logic?

Also,the dashboard has these values which is completely different from what you pasted:

• ###### 4. Re: How to made a summary table of data (SLA of time)

Hi Matias,

See solution below.

Create calculated field [ID Passed SLA?]

IF {FIXED [N° Solicitud]: SUM([IP (Tiempo Total)])} > 3 THEN 'No' ELSE 'Si' END

Create calculated field [Approve SLA]

COUNTD(IF [ID Passed SLA?] = 'Si' THEN [N° Solicitud] END)

Create calculated field [No Approve SLA]

COUNTD(IF [ID Passed SLA?] = 'No' THEN [N° Solicitud] END)

Create calculated field [Total IDs]

COUNTD([N° Solicitud])

Create calculated field [Approve SLA/(Total ID)]

[Approve SLA]/[Total IDs]

Hope this helps.

Ossai

1 of 1 people found this helpful
• ###### 5. Re: How to made a summary table of data (SLA of time)

Hi Nitin,

You have right, thats my fault, i configure bad the file to upload.

The good part is Okechukwu have the correct answer.

Thanks so much for take the time to answer and help me.

Have a wonderful week.

Greetings,

MM.

• ###### 6. Re: How to made a summary table of data (SLA of time)

Hi Okechukwu,

Thanks so much!, thats exactly that what i need!,

a BIG Thanks you,

have a wonderfull week,

Greetings!

• ###### 7. Re: How to made a summary table of data (SLA of time)

You are welcome Matias. Glad it helped.