Forum Discussion

Espen1515's avatar
Espen1515
Advocate I
8 years ago
Solved

Replacing (Blanks) with 0

Hi,   I have a number of Cards in my dashboard that return numbers. When I selected a filter where there no numbers, instead of displaying 0, it displays (Blank), and looks very ugly. Is there an e...
Need Help
  • Pavlous's avatar
    Pavlous
    8 years ago

    Espen1515,

    so you are using the raw source data, is it correct?

     

    So its easy to you just make new column with this code

     

    Column = IF(ISBLANK(**original column**),0,**original column**)

    **original column** - your name for the column you are using.

    Then change the value to the new column and it should work :)

rodlovely's avatar
rodlovely
Regular Visitor
6 years ago

If you want is to replace blank or null values with 0 without creating a new column, then use the Query Editor.

  1. Select Edit Query. 
  2. In the query window, right click on the column header and select Replace Values... 

Notes:

  • Pay attention to where you insert the command in your Query steps. 
  • You can select multiple columns by holding down the Ctrl key when you select the column header
  • You can view and modify the code in the Advanced Editor if needed.
  • You can replace any values with this method