Grouping Issue with Clustered Column Graph

3 posts, 0 answers
  1. Anil
    Anil avatar
    5 posts
    Member since:
    Sep 2018

    Posted 17 Sep 2018 Link to this post

    I am trying to create a clustered column graph that shows the number of services and appointments booked each hour, as depicted by mockup.jpg. I am pulling the data through a SQL data source as shown in data.jpg, where the first row represents the number of services booked and the second row represents the number of appointments booked. The column graph is set up such that each column pulled from the database is a series along the X-axis, and the row values are the Y values. However, for the graph series, the Report Designer seems to group rows that have the same value; an example of this problem is shown in issue.jpg. The 11AM category should have two bars, not one. The grouping issue does not occur with columns that have different row values; in the example, the 10AM column shows two bars as it should. I tried removing series grouping for the 11AM column, but it does not fix the issue.
  2. Todor
    Admin
    Todor avatar
    310 posts

    Posted 20 Sep 2018 Link to this post

    Hi Anil,

    I have attached a sample report demonstrating how to achieve the desired layout.
    Note how the data is structured in the embedded CsvDataSource of the sample.

    On the Graph:
    The Categories are grouped by Hours - i.e. each Hour will be one Category (one X-axis slot/value).
    The Series are grouped by 'group' ('services' or 'appointments')  - i.e. 'services' will be one Series, and 'appointments' will be the second Series. Thus, in each Category slot there will be two bars - one for 'services' and one for 'appointments'.
    Value (the number of services/appointments for the corresponding Hour) is represented on the Y axis.

    In case the suggested approach does not help, you can open a support ticket and attach a runnable report for local investigation.

    Regards,
    Todor
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. Anil
    Anil avatar
    5 posts
    Member since:
    Sep 2018

    Posted 20 Sep 2018 Link to this post

    Todor,

    Thank you for your help. I figured out the issue on my own; Telerik Reporting has a very specific way of looking at resultset data for charts. I rewrote my query to pull the data in such a way, even if its a bit more ineffecient.

    Thank you,

    Anil

Back to Top