Clustered Columns Chart with variable values

Stimulsoft BI Designer discussion
Post Reply
AndreasB_CH
Posts: 7
Joined: Fri Jul 02, 2021 1:18 pm

Clustered Columns Chart with variable values

Post by AndreasB_CH »

I have a table like this:
Chart_Table.jpg
Chart_Table.jpg (35.34 KiB) Viewed 710 times
Monat (month): number is variable depending on the selected time range.
AbtNr / Name (department number / name): number is variable depending on several arguments.
Quote (quota) is the value to be shown as percent

Now the chart should look like this:
Chart.jpg
Chart.jpg (31.36 KiB) Viewed 710 times
So first it should be grouped by month and within the month by department. How do I do this in designer (version is 2023.1.6)?
Lech Kulikowski
Posts: 6265
Joined: Tue Mar 20, 2018 5:34 am

Re: Clustered Columns Chart with variable values

Post by Lech Kulikowski »

Hello,

Please send your report with test data.

Thank you.
AndreasB_CH
Posts: 7
Joined: Fri Jul 02, 2021 1:18 pm

Re: Clustered Columns Chart with variable values

Post by AndreasB_CH »

If someone has the same problem:

Set Auto Series Key Data Column to AbtNr
Set Argument Data Column to Monat
Set Value Data Column to Quote

Thank you Lech for your support!
Lech Kulikowski
Posts: 6265
Joined: Tue Mar 20, 2018 5:34 am

Re: Clustered Columns Chart with variable values

Post by Lech Kulikowski »

Hello,

You are welcome.
Post Reply