Best Of
Re: Correcting date format in Magic ETL
@jhester yes, the formula tile in magic ETL gives you beast mode functionality within the ETL. You can overwrite existing columns or create new columns. You can find the formula tile under the utility section on the left side.
I have created a video that walks you through using the tile that you may want to watch.
Re: Filtering data will completely remove blank values
This is how DOMO has handled filtering with null values for awhile now; I can't remember if it was for New ETL or an update after that. I suggest assigning a value for the NULL values using Value Map or Formula in ETL.
CASE WHEN FieldA IS NULL THEN 'Blank' ELSE FieldA END
This should save the data from being deleted by your filter.
a10hall
Re: Filtering data will completely remove blank values
@Christianjmzc @a10hall This is actually normal behavior for SQL. If you tried it in SQL server or MySQL, you would get the same result because in SQL, nulls don't work with logical operators as you'd expect. This Wikipedia entry explains it pretty well:
Re: Single Value Card - No numeric abbreviations
In the General Chart Properties, for the Divide Value by property, set it to None.
Single Value Card - No numeric abbreviations
Is there a way to turn off abbreviations of numbers in Single Value card?
I have a card that has the value of 1023. It shows as 1.02K (I have it set to 2 decimal places). I can't find anywhere to tell Domo not to use the abbreviation on this card. (ether in the card settings or the value display settings).
