cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying data for null values

Jack_Machesky
9 - Travel Pro
9 - Travel Pro

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?

6 REPLIES 6

DRay
Community Team Member
Community Team Member

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.

David Raynor (DRay)

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

GSSC
8 - Cloud Apps
8 - Cloud Apps

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

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

When using this approach, I am met with "

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

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]))

bamo
8 - Cloud Apps
8 - Cloud Apps

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.