Chart Data Grouping
Posted: Thu May 12, 2022 10:01 am
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!
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!