hello. I have a chart widget that has on the x axis, years, while on the y axis the number of people. I want my chart widget to have different colors according to the field "country" of my database. I want it to look like the picture attached. Instead at the moment all columns are the same color.
Following are firther details of my chart:
Data: csv feature hosted file
Chart type: Bar chart
Data: by group
Category field: year (numbers)
Statistics: count
Sort by: category
maximum categories: /
Series
Stacking: stacked
etc.
Where can I select the other field to categorize my data? thank you