Best Of
Re: understanding null vs blank or empty string values
CASE WHEN COALESCE(TRIM(`field`), '') = '' THEN 'Blank' ELSE 'Not Blank' END
COALESCE will return the first non-null value it finds, used in this case it's saying if the field is null return an empty string. I've wrapped the field in a trim to remove any leading or trailing whitespaces in case someone has a value of all spaces to ignore. Then it is compared to an empty string after it's been converted.
A more verbose way would be:
CASE WHEN `field` IS NULL or TRIM(`field`) = '' THEN 'Blank' ELSE 'Not Blank' END
NULL is a very specific value. The only way to check for null is to use IS NULL or a COALESCE / IFNULL function to default it to a specific value and compare that value.
Most functions you use on NULL or comparison will result in a NULL value back because NULL represents the absence of data.
Re: YouTube Connectors Using YouTube Account Username and Password
@GrantSmith I've been trying to figure this out for at least two months and after rereading this post I looked into your solution of verifying that I was using the channel email address rather than the Gmail address of the content owner and that worked! It took me a while to find that email address, though.
YouTube Settings → In Account tab went to "Add or remove manager(s)" → View general account info → In Google Account went to "Personal Info" tab → And found the email address in the Contact info section
Re: YouTube Connectors Using YouTube Account Username and Password
Each individual channel will have their own "username" which you need to use to login to YouTube to authenticate and pull your data, not the admin username.
Re: Best practice for using the same dataset for different projects
One approach is to have a "raw" dataset with no BeastModes, and then save a view of the dataset for each distinct use/dasbhoard. Each view can have its own BeastModes. You can also limit the number of columns and rename the columns going into the dashboard, which can make the filters on the dashboard more user-friendly.
Domopalooza announces SHAQUILLE O'NEAL!
You can't spell Shaquille O'Neal without 'AI', and you can't host THE AI + Data Conference without Shaquille O'Neal! He's shattered backboards, won three NBA Finals MVPs en route to four championships, made a second career as a TV commercial legend, donated countless hours and $$ as a philanthropist, and won everyone's heart over as a television personality for the last 14 years. And now he's taking the stage at DP25. You can't get any bigger—in any way—than SHAQ.
Re: Ability to duplicate page in App Studio
Hi, you can access this feature using the new Import app pages feature released. Under pages and navigation, click on Import and select app pages - this should allow you to select any app (current app as well) and import not just one, but multiple app pages at once into your app. You can choose to duplicate your content or not using this flow.
Re: Failed to run dataset due to error from the bery beginning node
If you click on the configuration for your input dataset you can then expand the Data Handling menu, there will be one or more columns with a data type of Date, change them to Text. Then in your ETL you can handle any conversion issues downstream.
Re: "Send Now" Dashboard Feature - please add Card Descriptions
These are a collection of links to other ideas suggesting the same thing (descriptions in the email and/or PDF/PPT exports). Maybe we could upvote all of them? Or consolidate all their votes onto this idea?
https://community-forums.domo.com/main/discussion/56724/export-dashboard-to-ppt-enhancement?utm_source=community-search&utm_medium=organic-search&utm_term=descriptions