# Multiple Grouping in XY Charts and Bar Charts **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [October 8, 2025, 5:38am UTC](https://forum.inductiveautomation.com/t/multiple-grouping-in-xy-charts-and-bar-charts/111261 "2025-10-08T05:38:54Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![CHINTAPARTHI\_OM\_PRAK](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@CHINTAPARTHI\_OM\_PRAK](https://forum.inductiveautomation.com/u/CHINTAPARTHI_OM_PRAK)\ **Post date:** [October 8, 2025, 5:38am UTC](https://forum.inductiveautomation.com/t/multiple-grouping-in-xy-charts-and-bar-charts/111261/1 "2025-10-08T05:38:54Z")
Hello, could you suggest how I can implement multiple grouping by date, line, and shift, and then display the target and actual values in an XY chart component? I’ve created a named query to retrieve the data, and I’ve also provided the chart layout and data source to show how I want it to be displayed. ![graph](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/4/e4d051b629ffd3fc24b9a766ef54f97f438cdc49.png) ---
**Author:** ![CHINTAPARTHI\_OM\_PRAK](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@CHINTAPARTHI\_OM\_PRAK](https://forum.inductiveautomation.com/u/CHINTAPARTHI_OM_PRAK)\ **Post date:** [October 8, 2025, 10:23am UTC](https://forum.inductiveautomation.com/t/multiple-grouping-in-xy-charts-and-bar-charts/111261/2 "2025-10-08T10:23:55Z")
I need a suggestion on how to implement a group-by operation based on date, line, and shift, and then display the target and actual values in an XY chart component. I’ve already created a named query to retrieve the data, and today I managed to achieve a basic version of this. ![graph](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/4/e4d051b629ffd3fc24b9a766ef54f97f438cdc49.png) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [October 9, 2025, 3:57pm UTC](https://forum.inductiveautomation.com/t/multiple-grouping-in-xy-charts-and-bar-charts/111261/3 "2025-10-09T15:57:53Z")
You posted multiple times for the same thing - please don't do that. The first question is where you're displaying this chart - Vision, Perspective, or the reporting module? ---
**Author:** ![CHINTAPARTHI\_OM\_PRAK](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@CHINTAPARTHI\_OM\_PRAK](https://forum.inductiveautomation.com/u/CHINTAPARTHI_OM_PRAK)\ **Post date:** [October 9, 2025, 5:35pm UTC](https://forum.inductiveautomation.com/t/multiple-grouping-in-xy-charts-and-bar-charts/111261/4 "2025-10-09T17:35:51Z")
In perspective