Search code examples
domo

How do I omit certain data in a row without removing it all?

Domo zero example

I imported data from SQL into Domo. I am building a card and want to remove select 0 values without removing the entire row. Is this possible? The data type has to remain as integer because of the financial formatting.

Solution

  • You can achieve this in Domo using a Dataflow, in this case I used a MySQL dataflow.

    1: Create new MySQL dataflow using this dataset as the input

    2: Your transform would like this, where any column you want to remove 0's from would use that NULLIF function https://i.sstatic.net/UgoMb.jpg

    SELECT
`ProjectedExpenses`
,NULLIF(`Amount1`,0) as 'Amount1'
,NULLIF(`Amount2`,0) as 'Amount2'
,NULLIF(`Amount3`,0) as 'Amount3'
FROM `dojohelp99`

    3: The output dataset of this dataflow is just a select all from this transform table so that would be something like

    SELECT * FROM transform_data_1

    Final Result: https://i.sstatic.net/kmOBo.jpg