Best Of
Re: Filter NULL values within Analyzer
Domo can’t recognize a filter to show null records. The easiest thing to do is create a new field with a beastmode that is something like this:
CASE WHEN Brand IS NOT NULL THEN Brand ELSE ‘null’ END
Null values will then be replaced with the word Null and you can apply the filter as you would normally.
you could also use IFNULL() or COALESCE() functions to accomplish the same thing.
Re: Trying to call accounts API from brick
I don't believe this is possible within a Brick due to the security concerns around the storage and usage of account credentials.
Re: Automate DOMO pulling an Excel File
@ColinHaze You could use Workbench if the file is stored locally on your network. I believe you need to have admin rights to be able to download Workbench. If you use SharePoint you could also use that to automatically get the files. You may also be able to use some scripting with the Java CLI to do this as well. I think there is also an excel plug in where you can have a file directly connected to Domo and you can just click upload.
Ashleigh
Re: Case Statement Help
@leaflove Beast modes generally work best when the aggregate function is outside of the case statement instead of inside like this:
count(distinct case when `customerID` > 0 then `customerID` end)
Re: Automate DOMO pulling an Excel File
Is the file name, format, tab name, etc… remaining the same and just the data changing? If so, the files could be stored in OneDrive and you could use the OneDrive for Business connector in Domo.
Otherwise, this sounds like a job for Workbench
Re: Export Dashboard to PPT - enhancement
Yes, agreed! The export should appear the same as the dashboard for both PDFs and PowerPoints
Re: Export Dashboard to PPT - enhancement
Yes, please! Including the description would save so much whitespace when users insist on having a dashboard optimized for exporting to a PowerPoint or PDF.
Re: December 2023 Community Forum Highlights
@JasonAltenburg , we need to sync up regarding Domo for Good!
Re: Form and Dataset Brick Allow Users to Edit
This is not currently possible.
"Only the person that installed the app is able to edit the app. You can use “Save as” to make your own copy."
Re: Magic ETL - Copy Single Tile
Agreed! If I ever only need one tile I always have to copy the one before or after it and then delete it when I paste it.
Ashleigh




