Hi,
imagine having data for two years in the same table. the field is named year (filled with 2022 and 2023 accordingly). And another field named age_group (filled with young, adults and elders).
In a pie chart: I want to represent the count for each age group for 2022 on the left "half-moon" and on the right the same but for 2023. each half-moon is proportionally big to the total amount of records.
Therefore the chart should allow to choose a field to divide the pie (in example above the date) and another field for categories; finally to allow to make a proportion according to the totals for each year.
I hope u can do this,
cheers
Pedro