I've successfully created a range bar chart (Gantt chart, though that may be abusing the term), very similar to the attached sample.
I would like to alter it so that for the green "Running" segments, it actually uses a line chart to indicate the running rate, as in the second attachment.
I've read conflicting statements as to whether or not you can combine a line chart with a bar chart. Any suggestions on how to best accomplish this?
One idea I had was to manually construct the timeseries data in SQL - basically slice and dice the start/end intervals into timeseries data, assigning a magnitude (100% for all except the Running state, which would observe the running rate) and presenting the data to be used with a column chart - but that seems like it could get ugly and more importantly slow to query.