Best Of
Re: Where can I find the logic for custom built dimensions?
@Joe_M, if you aren't the owner of the dataset, you should also talk to the person that is managing that platform where these 'Segments' fields are coming from. They may have a taxonomy doc that will have each field defined.
amehdad
Re: How to make card of Monthly Total Sales & Price Per Unit and Summary Table With Corrected Color
Hi @LMS,
Here are some links to help:
amehdad
Re: Magic ETL Nested Case Statement
Thanks @MarkSnodgrass -- in the end, it was, as you had suggested a spelling error (which was not in my formula but was being outputted from the CRM automatically). Thank you!!
Re: Handle NULL in Magic
@TheLookout That's awesome! Thank you, this will save me a bunch of time.
Re: How to exclude BLANK values in histogram custom bins?
Hi @user000253
Are your values blank meaning an empty string '' or are they actually NULL meaning no data?
To handle both cases you could add an additional clause to your case statement with a COALESCE function:
CASE WHEN TRIM(COALESCE(`Flow Velocity (ft/s)`, '')) = '' THEN 'BLANK' WHEN CEILING(`Flow Velocity (ft/s)`)<= 10 THEN '0-10' WHEN CEILING(`Flow Velocity (ft/s)`)<= 50 THEN '10-50' WHEN CEILING(`Flow Velocity (ft/s)`)<= 100 THEN '50-100' WHEN CEILING(`Flow Velocity (ft/s)`)<= 150 THEN '100-150' ELSE '150+' END
COALESCE says to return the first non-null value it finds. So in this case if it's an empty string ('') it will return that value and compare it to an empty string, if it's null it will use the empty string to compare against instead of null. There's an extra TRIM in there just in case we have a value of all spaces to remove spaces from the beginning and end of our string (it would make a value of ' ' = '')
And then just filter out the BLANK value in your card.
Re: How to clean up clutter - User Conference Jan 2022 notes
Link to the Recordings: https://dojo.domo.com/discussion/54211/virtual-user-group-kickoff-recordings
BrettG
Virtual User Group Kickoff Recordings
Thank you to everyone that attended our first (of many) Virtual User groups! This event was geared towards our technical community and had an amazing turnout. I think we can all agree that we came away feeling a greater sense of community, collaboration, and learning than before. If you missed the event, or would like to rewatch the Solution Reviews, we've linked them below.
John Stevens: How to use Domo MetaData to keep a clean Instance
Aaron Dean: Framing and Scoping App Solutions with Domo
Grant Smith: Custom Period over Period Charts
Come to the next event live to catch our community updates, product Q&A and Domo executive segment.
Thanks to our amazing speakers for helping us uplevel our Domo skills. If you'd like to participate in our #ISolvedItWithDomo competition (awards will be given to the winners at Domopalooza), and haven't responded to the survey, email richard.carey@domo.com.
See many of you at Domopalooza in just a couple months!
