Chart Data Grouping

Stimulsoft Reports.NET discussion
Post Reply
paulm
Posts: 14
Joined: Tue Oct 19, 2021 7:11 am

Chart Data Grouping

Post by paulm »

Hello,

I'm trying to make a chart with data grouping. I attach a capture of the DB Structure:
BD Structure.PNG
BD Structure.PNG (54.81 KiB) Viewed 594 times
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:
Report.PNG
Report.PNG (112.05 KiB) Viewed 594 times
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:
Excel Chart.PNG
Excel Chart.PNG (35.27 KiB) Viewed 594 times
But I need to do the same in the report.

Thanks a lot!
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Chart Data Grouping

Post by Lech Kulikowski »

Hello,

You can add DataTransformation in which make necessary grouping and calculations and then use it for the Chart as data source.

Thank you.
paulm
Posts: 14
Joined: Tue Oct 19, 2021 7:11 am

Re: Chart Data Grouping

Post by paulm »

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.
Hello,

Thanks for the reply. I can't see the "New Data Transformation..." option.
Dictionary Options.png
Dictionary Options.png (49.91 KiB) Viewed 553 times
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.
Stimulsoft Version.png
Stimulsoft Version.png (24.54 KiB) Viewed 553 times
Thanks.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Chart Data Grouping

Post by Lech Kulikowski »

Hello,

In the WPF version, that option is not available.
You can use the "Data from other Data Source" source.

Thank you.
paulm
Posts: 14
Joined: Tue Oct 19, 2021 7:11 am

Re: Chart Data Grouping

Post by paulm »

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.
Hello,

I've tried this and now works fine.

Thanks a lot!
Max Shamanov
Posts: 768
Joined: Tue Sep 07, 2021 10:11 am

Re: Chart Data Grouping

Post by Max Shamanov »

Hello,

You are welcome!
Post Reply