4 Replies Latest reply on Apr 23, 2018 3:37 PM by swaroop.gantela

# Performance Profile Plot

In the attached Tableau 10.3 packaged workbook, I have data for two algorithms that were both run on the same set of problems.  I am trying to build a chart that gives two line graphs (one for each algorithm) showing the percent of problems solved within a given timeframe.  This type of plot is called a performance profile.  A previous question by Dan Meier on these forums is very similar, but was unanswered.

On sheet 1 I have a scatter plot that plots the points that I want, but I can't figure out how to make it show up as a line graph.

On sheet 2 I have the kind of line graph that I need, but the points are wrong.  This is easiest to see in the upper tails, where both algorithms couldn't finish about 15% of the problems in the 1800 second time limit.  Thus, both graphs should have vertical lines from ~85% up to 100% (see Sheet 1).  Instead Sheet 2 aggregates all these too-long problems and interpolates between the running time at ~85% and  the 1800 second running time at 100%.  This makes it look like (for example) OBM2 could solve 92% of the problems in 1000 seconds, which is not true.

How do I get the plot on Sheet 1 to show up as a line graph without Tableau aggregating and presenting interpolated running times?

• ###### 1. Re: Performance Profile Plot

Tim,

I haven't worked through it yet,

but I think the methods described in this post on Kaplan Meier curves

may be of use for you:

Essentially, there will need to be some data padding to get the

straight lines.

• ###### 2. Re: Performance Profile Plot

Tim,

I think this discussion may get you there:

Create a step chart in Tableau without Data Modeling - Data + Tableau + Me

• ###### 3. Re: Performance Profile Plot

Swaroop,

Great answer.  I was getting to the same result... just not as fast or as neatly as you do.  I wish there was a way that I could get a tooltip on each problem.  Unfortunately, we can't seem to break the aggregation, so that if we add "Problem" on the tooltip, the vertical lines have "Problem: *" in the tooltip.

• ###### 4. Re: Performance Profile Plot

Tim,

I'm not sure if this will break other things,

but maybe it will work with changing

the [Problem] pill on the Tooltip shelf to MIN(Problem):