Hello,
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!
Chart Data Grouping
-
- Posts: 6247
- Joined: Tue Mar 20, 2018 5:34 am
Re: Chart Data Grouping
Hello,
You can add DataTransformation in which make necessary grouping and calculations and then use it for the Chart as data source.
Thank you.
You can add DataTransformation in which make necessary grouping and calculations and then use it for the Chart as data source.
Thank you.
Re: Chart Data Grouping
Hello,Lech Kulikowski wrote: ↑Fri May 13, 2022 6:53 am Hello,
You can add DataTransformation in which make necessary grouping and calculations and then use it for the Chart as data source.
Thank you.
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.
-
- Posts: 6247
- Joined: Tue Mar 20, 2018 5:34 am
Re: Chart Data Grouping
Hello,
In the WPF version, that option is not available.
You can use the "Data from other Data Source" source.
Thank you.
In the WPF version, that option is not available.
You can use the "Data from other Data Source" source.
Thank you.
Re: Chart Data Grouping
Hello,Lech Kulikowski wrote: ↑Fri May 13, 2022 1:08 pm Hello,
In the WPF version, that option is not available.
You can use the "Data from other Data Source" source.
Thank you.
I've tried this and now works fine.
Thanks a lot!
-
- Posts: 786
- Joined: Tue Sep 07, 2021 10:11 am
Re: Chart Data Grouping
Hello,
You are welcome!
You are welcome!