none
Column chart in SQL BI

    Question

  • Hi,

    I have this table:

    Product (char)

    AtStation1 (datetime)

    AtStation2 (datetime)

    AtStation3 (datetime)

    I created column charts for each station showing how many total (count) products at AtStation1 , 2 and 3 ant any given time.  One axis is the count of products and the other is time.  I though since the axis are the same I should be able to show (superimpose) all these 3 column charts in to one.

    How do I achive this.

    Thanks.


    AE

    Tuesday, November 19, 2013 4:02 PM

Answers

  • Hi AE,

    If I understand correctly, you want to display these data in one chart.

    In SQL Server Reporting Services (SSRS), a chart supports nested category and series groups. However, it is not support adjacent category and series groups. So, we cannot display AtStation1, AtStation2 and AtStation3 values in one X-axis. If we are having the same X-axis in the chart, we can add more than one field in the Values dialog box. These fields are in the same level.

    As sathya posted earlier, could you please post your dataset with sample data, and the screenshot about your expected output? We may work around the issue.

    If there are any misunderstanding, please feel free to let me know.

    Regards,
    Alisa Tang

    If you have any feedback on our support, please click here.


    Alisa Tang
    TechNet Community Support

    • Marked as answer by AE from SFO Monday, November 25, 2013 7:50 PM
    Wednesday, November 20, 2013 11:47 AM

All replies

  • Hi AE,

    Are you trying to create stacked bar chart .


    sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

    Tuesday, November 19, 2013 4:26 PM
  • Thank you for your quick response. The three individual ones I created were just column charts.  Then I tried to create a stacked column chart to show all in one chart but I am getting weird results.  Should I used stacked bar chart? What should be my Category groups?

    AE

    Tuesday, November 19, 2013 6:09 PM
  • I should have made this clear:  times are in Date&hour and the axis is showing the hourly totals.  Thanks.


    AE

    Tuesday, November 19, 2013 6:37 PM
  • Hi AE,

    Could you please post screenshot of report and expected output with sample data , so that someone can help you with more appropriate answer .


    sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

    Wednesday, November 20, 2013 2:21 AM
  • Hi AE,

    If I understand correctly, you want to display these data in one chart.

    In SQL Server Reporting Services (SSRS), a chart supports nested category and series groups. However, it is not support adjacent category and series groups. So, we cannot display AtStation1, AtStation2 and AtStation3 values in one X-axis. If we are having the same X-axis in the chart, we can add more than one field in the Values dialog box. These fields are in the same level.

    As sathya posted earlier, could you please post your dataset with sample data, and the screenshot about your expected output? We may work around the issue.

    If there are any misunderstanding, please feel free to let me know.

    Regards,
    Alisa Tang

    If you have any feedback on our support, please click here.


    Alisa Tang
    TechNet Community Support

    • Marked as answer by AE from SFO Monday, November 25, 2013 7:50 PM
    Wednesday, November 20, 2013 11:47 AM
  • Thank you Satya. The first chart (stacked column) in the first image is what I get when I try to show all the following 5 column charts in first and second images.  I put these dates in Values and in Category Groups in the Stacked Column chart.

    It is close to what I want except, colums have vertical gaps and does not seem to have any relationship with the count (vertical axis).  The tool tip shows counts that it does not make any sense.

    Here is the data behind it:

    Acc Number

    Collected

    In Lab

    Received

    Performed

    Verified

    17UU13001555

    11/12/2013 10:00

    11/12/2013 11:00

    11/12/2013 18:00

    NULL

    11/13/2013 16:00

    11UU13016184

    11/12/2013 12:00

    11/12/2013 13:00

    11/12/2013 18:00

    NULL

    11/13/2013 16:00

    11UU13016176

    11/12/2013 10:00

    11/12/2013 11:00

    11/12/2013 18:00

    NULL

    11/13/2013 16:00

    11UU13016193

    11/12/2013 10:00

    11/12/2013 13:00

    11/12/2013 18:00

    NULL

    11/13/2013 16:00

    11UU13016178

    11/12/2013 11:00

    11/12/2013 11:00

    11/12/2013 18:00

    NULL

    11/13/2013 16:00

    11UU13016181

    11/12/2013 11:00

    11/12/2013 13:00

    11/12/2013 18:00

    NULL

    11/13/2013 15:00

    17UU13001557

    11/12/2013 12:00

    11/12/2013 12:00

    11/12/2013 18:00

    NULL

    11/13/2013 23:00

    11UU13016183

    11/12/2013 12:00

    11/12/2013 13:00

    11/12/2013 18:00

    NULL

    11/13/2013 16:00

    11UU13016173

    11/12/2013 10:00

    11/12/2013 10:00

    11/12/2013 18:00

    NULL

    11/13/2013 16:00

    11UU13016198

    11/12/2013 12:00

    11/12/2013 14:00

    11/12/2013 23:00

    NULL

    11/14/2013 0:00

    11UU13016180

    11/12/2013 11:00

    11/12/2013 13:00

    11/12/2013 18:00

    NULL

    11/13/2013 16:00

    11UU13016218

    11/12/2013 12:00

    11/12/2013 19:00

    11/12/2013 23:00

    NULL

    11/13/2013 19:00

    11UU13016194

    11/12/2013 11:00

    11/12/2013 14:00

    11/12/2013 18:00

    NULL

    11/14/2013 7:00

    11UU13016179

    11/12/2013 11:00

    11/12/2013 11:00

    11/12/2013 18:00

    NULL

    11/13/2013 16:00


    AE

    Wednesday, November 20, 2013 5:31 PM
  • There seem to be problem with the image upload.  The files size well below the limit 1024 KB.  I see the weel going round and round for ever (waited for several minutes).  I will try again shortly.

    AE

    Wednesday, November 20, 2013 5:38 PM
  • Okay, I tried it again; clicked on the Insert Image icon then Upload, selected the file, the turing weel appeared, left it for 10 minutes, came back, still turning.  Clearly it is not working for me.  Any ideas?

    AE

    Wednesday, November 20, 2013 7:19 PM
  • Hi,

    Did you find a solution to post the screenshot? I agree with Alisa, what you want is not support in SSRS. If we can merge these three fields in one field, we can achieve the effect.

    Thursday, November 21, 2013 11:40 AM
  • Is this what you want?

    Overlapping bar chart

    If yes, check out my blog post

    http://www.sqljason.com/2012/03/overlapping-charts-in-ssrs-using-range.html


    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 21, 2013 2:48 PM
  • Thank you for the information Alisa.  I have changed the data structure to:

    Product, Station Name, Time

    using a storeprocedure to get around my problem.


    AE

    Monday, November 25, 2013 7:50 PM
  • Thank you Jason.  Your blog was helpful.

    AE

    Monday, November 25, 2013 7:52 PM