Multiple Grouping in XY Charts and Bar Charts

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.