I’m following up to see if the solution offered by HamzaJ worked for you.
If so, please click the 'Accept as Solution' button on their post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.
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.
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.
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.
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.
Rafael Ferreira
OP7 months agoHi DRay ,
The answer provided did not provide I solution. I will try a support ticket.
DRay
·7 months agoHi Astroraf,
I’m following up to see if the solution offered by HamzaJ worked for you.
If so, please click the 'Accept as Solution' button on their post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.
Thank you.
HamzaJ
·8 months agoHey 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;
Hamza
Rafael Ferreira
OP8 months agoHi 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.
HamzaJ
·8 months agoHey 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
irismaessen
·6 months agoHi 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.