1 2 Previous Next 15 Replies Latest reply on Dec 21, 2017 7:14 AM by Gregg Hirshberg

# Percentile of Duration

I am trying to figure out the calculation(s) to determine when 80% of these work orders are completed.

For example, while I understand the average duration for these 592 orders is 29.6 days, I need to know how long the majority are taking.

• ###### 1. Re: Percentile of Duration

Hi Gregg,

Hope this helps.

Regards,

Shin

3 of 3 people found this helpful
• ###### 2. Re: Percentile of Duration

Hi Gregg

See the attached

Several calculations

First the duration

Then the duration level at 80% of complete - note I used a fixed calculation - you may need to add dimensions infront of the colon if you plan to slice your real data up more finely

Next are the count of the WO's and the total duration

and

it returns this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

2 of 2 people found this helpful
• ###### 3. Re: Percentile of Duration

Hello Gregg Hirshberg

See the attached...I created a calculated field to find the percentile of the the average aging.  Then used that as a filter.  The issue is being able to recalculate an average after this filter is applied.  We can't use and LOD because the order of operations calculates those fields before the measure filter is applied.  Also, if we remove WO#, we lose the percentiles.  I think the result is insightful, although if you are looking for a hard average aging value, I wasn't able to find a way to get you one.

Best,

Matthew

2 of 2 people found this helpful
• ###### 4. Re: Percentile of Duration

I think this is really close, but I can't seem to get it to display as just the number. Only seeing it in the chart. What am I doing wrong?

This data is for one task, the actual dashboard will be looking at 160 tasks.

Thanks!

1 of 1 people found this helpful
• ###### 5. Re: Percentile of Duration

Hi Gregg

is this what you want

See my reply above for the detail

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 6. Re: Percentile of Duration

Not quite. I want to see that 80% of the WOs are completed within 51 days.

1 of 1 people found this helpful
• ###### 7. Re: Percentile of Duration

Like this

see attached

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 8. Re: Percentile of Duration

Thanks, Jim, But I know it's 51 for this task, the end product will have a lot more tasks and I won't know the targeted 80% number.

For now I'd like a table that looks like this, with another column that shows the 80% target. And then when I use the entire data set, the 80% will show for each task.

• ###### 9. Re: Percentile of Duration

That's based on how to show them.

When you add dimensions, you need to change the table calc setting accordingly though.

Which I am not sure what you want at this point.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 10. Re: Percentile of Duration

That is so close. And it's my fault, for the limited sample data I supplied. I took this calculation and added it to my dashboard, and I'm running into an issue, where I can't seem to get it for all the tasks. I've updated the sample data set, so now it includes 2 tasks.

On Sheet 1, for some reason, the numbers aren't lined up correctly. I think it's because of having Aging in the detail. What I need in the end, is something like sheet 3. Where I'll have my task, the count of WOs and then the 80%ile number for that task. I tried updating the calculation to be fixed on the task, but it's giving me a number that I don't understand (795?)

Really appreciate the help. Can you please help me tweak it just a little more, and I think we'll be there?

Thanks!

• ###### 11. Re: Percentile of Duration

Hi Gregg,

mmm,

Looks easy, but actually this requires Very complicated background tasks or workaround.

the difficulty here is

- 80 %ile calculation requires lowest level of granuarity (Aging) in the table itself.

- Once "Aging" is added, all other normal calculation are broken, then you need to modify all these calculation to table calc of "window_***"

Put Aging and WO# as dimension

Then complicated table calc setting.  Follow the instruction Very carefully..

These duplicates all the fields.

I agree, you can call this as Tableau's ****.....

Tableau is really not good at to create flexible table view..

Thanks,

Shin

1 of 1 people found this helpful
• ###### 12. Re: Percentile of Duration

I can't figure out what I'm doing wrong. I've taken your calculations and applied them to my larger data set, and I can't seem to get the 80% to populate in my table.

Can you see anyplace that I'm screwing this up?

Thanks!

• ###### 13. Re: Percentile of Duration

Guessing drop down??