Displaying data for null values

I have multiple widgets on my dashboard that I would like to show values of "0" for if they are null values. What is the best way to achieve this?

Jack_Machesky

Posted 2 years ago·Last reply 2 years ago

6 comments

bamo

·2 years ago

hii...You can achieve this by setting up conditional formatting or logic in your dashboard software to replace null values with "0" before displaying them.

GSSC

·2 years ago

Assuming you are using the formula SUM([Revenue]) you could try:

CASE WHEN ISNULL(SUM([Revenue])) THEN 0 ELSE SUM([Revenue]) END

Jack_Machesky

OP2 years ago

When using this approach, I am met with "

Error querying your data model An unknown error has occurred."

Jack_Machesky

OP2 years ago

It looks like this approach is working for a formula that only contains a SUM function, but when I try and use it for a formula using a PASTYEAR(SUM()) formula, it is not working. I will paste my formula it is not working for below: Pastyear(sum([Total Sales]))

DRay

·2 years ago

Hello Jack_Machesky,

Can you take a look at this documentation and let us know if it addresses your use-case?

https://docs.sisense.com/main/SisenseLinux/replacing-missing-values-with-zeros.htm

Thank you.

Jack_Machesky

OP2 years ago

Hello David,

In my case, this does not solve the issue I am facing. I am looking at blox widgets that are pointed at a salesforce database, and was wondering if I could return values of 0 for all null values.

Thanks,

Jack