Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
150
Infragistics.Reports.Chart grouping problem
posted

I'm having a problem where I can't get a chart to group data properly.  Specifics:

  • I have created a database where-in an employee belongs to one specific group.  Each group has a unique set of questions that can be asked that are related to work that an employee in a specific group did.  Each question is assigned a category.
  • The required result is to be able to show the average value for each specific category in a specific group.  Thus, I thought I would use a chart to show that data.

 

Here is a screenshot of example data after being queried (this query is what my report is based upon):

 

Next, I added a group to my report and populated it with the Name field from above.  Last, I put the chart in the group body (not the report DetailSection) and assigned the CategoryXAxis to the Category field from above, and the ColumnSeries to Result_Average from above.

The result that I'm getting is that the first page will be the 'HVAC Sales' group, but as opposed to the chart showing the category averages for each of its categories, it's showing the averages from all groups.  So i would expect to see one vertical bar above "Overall Performance".  But instead, I see 5 vertical bars over that category.  Screenshot:

 

Anyone have any idea as to what I'm doing wrong?  Thanks.

 

Parents
  • 3070
    posted

    Hi Brad,

    This is a limitation we have in the CTP. You can only assign the entire datasource to a chart. So even though you place the chart inside a group it will not be filtered. This limitation will be removed for V1.

    Thanks,

    Leo

     

     

     

Reply Children