I have a table like this:
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:
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)?
Clustered Columns Chart with variable values
-
- Posts: 7
- Joined: Fri Jul 02, 2021 1:18 pm
-
- Posts: 6337
- Joined: Tue Mar 20, 2018 5:34 am
Re: Clustered Columns Chart with variable values
Hello,
Please send your report with test data.
Thank you.
Please send your report with test data.
Thank you.
-
- Posts: 7
- Joined: Fri Jul 02, 2021 1:18 pm
Re: Clustered Columns Chart with variable values
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!
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!
-
- Posts: 6337
- Joined: Tue Mar 20, 2018 5:34 am
Re: Clustered Columns Chart with variable values
Hello,
You are welcome.
You are welcome.