Modified range bar chart

Posted on 2014-08-07
Last Modified: 2014-08-11
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.
Question by:jdallen75
    LVL 47

    Accepted Solution

    >>"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.)

    Author Comment

    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).
    LVL 47

    Expert Comment

    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.

    Author Closing Comment

    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.
    LVL 47

    Expert Comment

    great! thought it might be simple ("it might even be trivial") -  you never know if you never try :)

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how the fundamental information of how to create a table.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now