I have a field called ‘status’ in that field i use values between 1 till 5 (each value stands for the status of the record)
in the same record i use a category field (cat) which contains a category id.
a category_id comes with multiple status values
like for example
3 times the number 1
4 times the number 2
1 time the number 4
6 times the number 5
now i want to stack up the status per category in a barchart. so that each category has it’s own stacked bar with the different status values in one plain sight.
so i used grid with summary, charts and nothing seems to work.
any suggestions how i can do this properly?