none
SSRS 2008 R2 Range Chart - Multiple data points in one day, spanning last 30 days

    Question

  • Hi,

    I am not so sure this is possible and I have trawled over various videos and guides from various posts on range charts in 2008R2 e.g. pnarayanaswamy blog

    I have data that shows start and stop times for a machine (truck) on a given day, for the last 30 days. I am trying to show days of operation on the vertical Axis (last 30 days) and the horizontal axis to display various ranges inside a given day illustrating the duration of start and stop times.

    Is this possible?

    See attached image of potential end result except it would span 30 days not just one.

    Wednesday, November 06, 2013 2:32 PM

All replies

  • I cannot seem to add a picture but a bit more information:

    Data:

    Task/Date         start                                          end
    ====                ======                                                ====
    2013-11-06        2013-11-06 07:00:00.000            2013-11-06 07:50:00.000
    2013-11-06        2013-11-06 07:50:00.000            2013-11-06 08:20:00.000
    2013-11-06        2013-11-06 08:20:00.000            2013-11-06 09:10:00.000
    2013-11-06        2013-11-06 09:10:00.000            2013-11-06 09:40:00.000
    2013-11-06        2013-11-06 09:40:00.000            2013-11-06 10:20:00.000
    2013-11-06        2013-11-06 10:20:00.000            2013-11-06 11:10:00.000

    I added start for TopValue, end for bottomvalue and task for categories. I tried everything that is in this blog like enable variable interval, draw side by side etc. but nothing resolved my problem.

    I am getting a graph like

    |
    |
    | ----
    |
    | ----
    |-----------------------------------------
    07:00 08:00 09:00 10:00 11:00 12:00

    Wednesday, November 06, 2013 3:17 PM
  • Hi KarlMcAuley,

    Thank you for your question.

    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.

    Thank you for your understanding and support.

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Thursday, November 07, 2013 12:27 PM
    Moderator
  • can you upload your picture (how you want it to be and how it comes right now) to a image hosting site like ImageShack.com and paste the url here?

    Cheers,
    Jason | www.SqlJason.com
    P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

    Some Random Thoughts

    Follow me on Twitter

    Thursday, November 07, 2013 6:44 PM
    Moderator
  • Hello KalrMcAuley,

    Can you provide us an image as to how you expect the graph to appear? Also does the data for each row would contain the only 3 columns as shown in the post or will it contain more columns?
    What is being plotted as values in the chart? Is there some column that carries truck number / any info?

    Please help me answered with the above questions and information.

    Regards
    Durai Murugan

    Wednesday, November 13, 2013 4:57 PM