1 of 1 people found this helpful
How about something like the attached? Instead of using the Bar Mark, where the length of the bars is based from 0 (or the prior measure for a stacked bar) to the measure value, I used the Gantt Bar Mark, where the length of the Bars is based on what is on the Size Shelf and the starting point is the measure value.
It looks like the origin is the average of the results, so I created the following calcs to do this:
WA SAT: WINDOW_AVG(AVG([SAT]))
This table calc computes an overall average and is used as the measure on the Rows shelf.
SAT Bar Length: ATTR([SAT])-[WA SAT]
This calc computes the length (Size) of the bars and is used as the measure on both the Size shelf and the Color shelf.
I also created a reference line based on WA SAT to provide a fake axis line, and edited the axis so it only shows the top %.
This is exactly what I am looking for, Thanks Jonathan, never knew gantt chart can be used this way.