Solved
COLUMN CHART SHOW ALL CATEGORIES EVEN IF NULL/0/MISSING
Please reference the attached excel worksheet. My goal is to show all horizontal categories, even when data = null/0/N/A.
Currently, only 3/6 categories appear and I've tried nearly every Sisens...
Hi cartercjb ,
I don't think that this is possible within Sisense with only enabling a certain option. What you could do is create a filtered measure per category. It will be labor intensive if you have a lot of categories.
You can do this by adding a measure and writing something like
(COUNT([Metric]), [ NTA CASE MIX])
You can click on [NTA CASE MIX] and select filter. Filter on NA and press OK. Repeat this for the other 4 . You will notice that even though count = 0 it will still show. (remember to remove NTA CASE MIX from Categories)
