Modified range bar chart

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.
RangeBarChart.png
RangeBarChart-Modified.png
jdallen75Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PortletPaulfreelancerCommented:
>>"assigning a magnitude (100% for all except the Running state"

I think that is probably the only way. Basically you want non-green to be full height (100%) but green to vary (<=100%)

It might add complexity to the underlying query, but it may be acceptable. (Hard to tell without any insight into the current query.)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jdallen75Author Commented:
Paul, thanks for the comment. Just imagine the current query returning a set of back-to-back events - with start and end times - and one of the fields is one of four states. Additionally available is time series data representing the run rate (which is zero in a non-running state).
0
PortletPaulfreelancerCommented:
I can picture some data in my head but it won't mean much to you :)

Let's say the run-rate data has an absolute max value of 1000 (full range 0 to 1000)
then the non-run-rate data would need to be plotted at a "rate" of 1000

I pretty sure we both agree on that technique, but how you "trick" this assumed rate into your data I'm not sure. It may not be difficult (it might even be trivial) - but I can't offer any specific advice without the existing queries to look at. Even then I might not know the answer.
0
jdallen75Author Commented:
It was actually quite straightforward: join the MachineState interval data with the timeseries RunningRate data, and bump up the non-running RunRates to the maximum across the set.
0
PortletPaulfreelancerCommented:
great! thought it might be simple ("it might even be trivial") -  you never know if you never try :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.