How to Display Category with 0 Values in Bar/Line Chart?
Hi HamzaJ DRay ,
Is there a way to display Categories with no data/zero value in a line or bar chart in Sisense without a widget edit script?
Forum Discussion
Hey Astroraf ,
I think it is dependent on how the data is stored. If it is in the same table i think a you can do this with a formula that counts all categories (e.g. count(categories), ALL(filter1),All(Filter2)) . If it is stored in multiple tables then i do not think it is possible, unless;
- you are on the newest linux version of sisense which supports join types and you can select a different join type then inner join
- if the amount of categories is limited you can apply a measure filter (e.g. (count(ID), Category=A) per category and repeat it.
Hamza
Hi HamzaJ
The formula is total of some value lets say total emissions, I want to show all the categories even if they have a zero value. They all coming from the same table.
For the formula: SUM([Total Emissions])
Assumption: (SUM[Total Emissions], ALL(Category)) -> Not sure if this would work.
Hey Astroraf ,
I know there is a way to do this, but i cant recall the correct formula/steps. I tried it myself but couldnt get it. If there are not to much categories you could try the measured filter route. Otherwise I think a edit on datamodel level is needed.
Hamza
Hi Astroraf, HamzaJ
I no longer have access to a Sisense instance, but I've had luck in the past with adding either +0 (or something like it) to my formula, or using, in the formula, a value from the dim table that I need to show all the values from. So something like SUM([Total Emissions]) + Count([Category])-1.
Where Count([Category]) will always be 1 in your pivot/bar chart because it's the category you're splitting on.
