I'm trying to make a chart with data grouping. I attach a capture of the DB Structure: I've got many rows with some information (Execution Time, Date, Unproductive(Y/N Boolean), Machine, etc). I need to see in a pie chart the total of execution time grouped by the UnproductiveType. Now the pie chart displays each line separately.
I attach the result of the report: In this example, lines 3 and 5 should be displayed as a group, but the chart displays them separately. The same with all UnproductiveTypes at the report.
How do I get to group by UnproductiveType?
In chart properties, I put "Result.UnproductiveType_Description" as argument and "Result.ImputationMO_ExecutionTime" as value. That's wrong?
In Excel is very easy to group data in charts: But I need to do the same in the report.
Thanks a lot!
You can add DataTransformation in which make necessary grouping and calculations and then use it for the Chart as data source.
Thanks for the reply. I can't see the "New Data Transformation..." option. I've got the 2022.2.4 WPF v2, .NET 4.5.1 version. The software is executed in our ERP software from the distributor. Thanks.
In the WPF version, that option is not available.
You can use the "Data from other Data Source" source.
You are welcome!