Page 1 of 1

Clustered Columns Chart with variable values

Posted: Wed Feb 14, 2024 9:34 am
by AndreasB_CH
I have a table like this:
Chart_Table.jpg
Chart_Table.jpg (35.34 KiB) Viewed 12061 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 12061 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)?

Re: Clustered Columns Chart with variable values

Posted: Thu Feb 15, 2024 8:46 am
by Lech Kulikowski
Hello,

Please send your report with test data.

Thank you.

Re: Clustered Columns Chart with variable values

Posted: Fri Feb 16, 2024 2:11 pm
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!

Re: Clustered Columns Chart with variable values

Posted: Fri Feb 16, 2024 3:14 pm
by Lech Kulikowski
Hello,

You are welcome.