Show blanks as a category in a stacked bar chart

[jbchurchill]

I have a stacked bar chart and I want to set it up to include blanks (no value) as a category and I cannot seem to figure out how I might do that.

The length of the bars (the measure) is based on number of services (outgoing_id)

Count([outgoing_id])

The two dimensions are as follows
for the stack (just a field =issue_code). This is the one that has blanks

The other dimension is also just a field for the contact type (=contact_type)

We want to reflect that a large % of the time the issue isn't specified (blank) but I cannot seem to include it in the chart (they don't appear to be in there anywhere). You can show null values for the other things but not for the stack. I cannot go in and calculate the blank values to be some value because it is in a data stream.

BLANK should be here to dwarf the other categories but it is not.

[mato32188 · Accepted solution]

Hi,

try to include null values in your dimensions and include zero values in Add-Ons, Data handling section of your object.

BR

m

[jbchurchill]

As simple of an answer as it is, I will probably have to accept this because it does answer the question. It isn't doing what I want though currently. I had "show nulls" checked but for some reason the sorting is putting them at the bottom and I didn't even see them even though the chart should be sorted by the number of values in the category (I want them treated as a category). So even though the bar is longer, it shows up at the bottom. I wonder if there is any way to force it to be at the top?