I have a data translation that has 2 levels of grouping. How can I turn this into a stacked chart?
E.g. My data looks like this after grouping it on Field1 and the Field2:
Field1 | Field2 | Total
Value1| ValueA| 1
Value1| ValueB| 3
Value2| ValueA| 3
Value2| ValueB| 2
Value3| ValueA| 4
I want to turn this into a stacked chart, where the there is a bar for value1, value2 and value3 which is divided into the totals for Field2. This is very easy to do in most reporting software, but I can't seem to figure out how to do it in stimulsoft reports. Do you have any hints on how to achieve this?
Stacked chart based on sub grouped data.
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: Stacked chart based on sub grouped data.
Hello,
Could you send us a sample in Excel that shows what you want for analysis?
Thank you.
Could you send us a sample in Excel that shows what you want for analysis?
Thank you.
Re: Stacked chart based on sub grouped data.
I have attached an excel example of the chart I am trying to achieve. The data in the spreadsheet basically represents the result of my data transformation.
- Attachments
-
- ChartExample.xlsx
- (17.92 KiB) Downloaded 61 times
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: Stacked chart based on sub grouped data.
Hello,
You can use the AutoSeriesKeyDataColumn property.
Thank you.
You can use the AutoSeriesKeyDataColumn property.
Thank you.
- Attachments
-
- Screenshot 2023-05-18 220736.png (193.21 KiB) Viewed 630 times
Re: Stacked chart based on sub grouped data.
Perfect, thank you. I knew there had to be an option I was missing, but I couldn't find any documentation explaining it.
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: Stacked chart based on sub grouped data.
Hello,
You are welcome.
You are welcome.