Best Of
Re: Alert Center
From the Settings, click the "Already Shared with" dropdown and it will let you manage the users.
a10hall
Re: Combine columns except when null (i.e., skip null)
My solution is kind of a work-around but the basic idea is to use a delimiter to combine the columns and remove them later on:
- Add a comma (or another delimiter) to the end of each text column that need to be combined (e.g., cat --> cat,)
- Combine the columns (will look something like cat,dog,,,bird,,)
- Replace text LIKE ',,%' with ','
- Replace ',' (or comma no space) with ', ' (or comma with space)
- Remove last char
Domopalooza Registration is LIVE
This year's theme: MULTIPLY YOUR IMPACT.
Join us and other business innovators for inspiration and insight to multiply your impact through data.
Learn more and Domopalooza 2023 and register for free HERE.
Re: Dataset View
I will also add that views are dependent on another actual dataset in your instance, which you can find in the Lineage tab of the view in the data center. If you just need cards powered by the view to refresh daily, you would need to manage that in via the schedule settings of the source dataset.
Re: Window function - unique ranking
You wouldn't want to order by your header as that'd have all the 0s first then the 1s so likely your row is at the end of your dataset.
Try sorting based on your Row_Number field instead.
Re: How can we apply drill down functionality between two dashboards in domo?
@Jaymin You can do this by configuring the interaction for each card on the first dashboard to redirect to the second dashboard, like below:





