I want to show the sales revenue of my department in a chart, split up into regions.
I chose a line chart to do so. It gives me one line for each of my three regions.
The problem is that there a revenues that are not assigned to a region (in the data, this field is just empty). How can I include a forth line in my chart, that shows "other region" / "not assigned region"?
I want this chart to be fixed, no matter what region the user selects.