Forum Discussion
Solved
Small Multiples chart
How can I get rid of blank values in a bar chart. I used small multiples and this is what I get But I want this
Expand the Territory/Region hierarchy.
A matric or table view wouldn't give me the bars though right? I need the bars. Here is some dummy data with the same set-up as my actual data.
| Territory | Region | Score |
| A | 1 | 84 |
| A | 2 | 91 |
| A | 3 | 85 |
| A | 4 | 86 |
| A | 5 | 82 |
| A | 6 | 84 |
| A | 7 | 81 |
| A | 8 | 92 |
| B | 9 | 75 |
| B | 10 | 83 |
| B | 11 | 86 |
| B | 12 | 84 |
| B | 13 | 87 |
| B | 14 | 80 |
| B | 15 | 79 |
Like this?
Thanks, that worked to get me the view, but last thing, can I adjust bar colors based on a column. Particularly the Region color in this dummy data?
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.