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.

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.

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?

1 Like

In perspective