Best Of
Congratulate our newest Community Coach, Rob!
Huge shoutout to @RobSomers who just hit the highest rank on the Community Forums! This is an amazing achievement — it takes a lot of work and time spent in the Forums to climb to the top.
Thanks @RobSomers for helping so many users in the Domo community.
Send @RobSomers some excitement in the comments below 👇
Get to know our newest Community Coach, Aquib Mehdad
Congrats to @amehdad, one of our newest Community Coaches! Aquib is an amazing peer and mentor on the Community Forums.
Learn more about Aquib and his journey with Domo and the Community Forums in this Q&A article on the Domo Community blog.
Comment below if @amehdad has answered one of your questions or contributed to your discussions in the Community Forums 👇
Re: Is Domo treating 0 as NULL? Card filtering 0 value as NULL
I got the same behavior when trying to exclude Null / NaN value from Integer.
My workaround is to use the beastmode below to exclude the Null
Example unfiltered data
When is NaN = 0
michiko
Re: Join vs Append
I hope I understood your question correctly. Here's my attempt.
Assume Defect DS has these values. ie 01 Jan ~ 30 Defects, 02 Jan ~ 48 Defects
Machine Volume DS has these values. ie 01 Jan ~ 6000 vol, 02 Jan ~ 15000 vol
Parts per Million (no of def (each day) / vol * 100000)
- 01 Jan = 30 / 6000 *100000 = 500
- 02 Jan = 48 / 15000 * 100000 = 320
Append the data
2 Beast Modes
Chart
michiko
Re: Is there a way to store a beast mode in a filter on a dashboard?
@MichelleH It worked! All I did was replace the 30 with my variable, and 60 with my variable * 2 in my beast mode, added the variable control in the dashboard and was able to input any number of days I'd like to look at. Thanks again. So easy.
Re: Case statement with multiple conditions
@renee12345 It looks like you're just trying to find the first exclusion reason that isn't null. You'll want use the COALESCE() function:
COALESCE('exclusion reason 1','exclusion reason 2',…)
COALESCE looks through the first field listed and if it's null, moves on to the next field, and repeats the process until it finds a non-null value.
Re: Colour change depending if beating last years amounts
#1 - Structure your data like this ( ie add a column called LY Amount )
#2 - Create some fancy beast mode calcs
#3 - Define the color rules
#4 - And finally… hack the hell out of the Line + stacked bar chart.
Tadaaaaaa
michiko
Re: Rank and Windowing functions in beast mode
@dacorson re: case sensitivity.
keep in mind that Analyzer is a UI for building viz AND defining queries that get to SQL. it is possible (though I am uncertain) that when you create a beast mode that the validator checks for case sensitivity; however the database itself is not case sensitive for column names.
i don't know. but i could see it being true. for sure the collation is case sensitive insofar as if you search for column LIKE 'aBC' will not yield the same results as column LIKE 'ABC'
Re: Cleaning data off an appending dataset
@user045907 - Have you considered using dataset views to filter the data to only the rows you want to keep?
Be a Friend! 'Accept' your Peer's Answers.
Hello Domo Community!
You have all been nailing it in the forum lately! Responses have been LIGHTNING⚡️fast and each post is getting at least one comment.
By way of reminder, don't forget to click the 'YES' button if a user answers your question. This is a great way to recognize your peers and help them accrue points on the forum!
If a comment does not answer your question, you can click the 'NO' button and then leave a comment explaining why. This way, more members can continue to help you find a solution to your problem.
Remember to always appreciate the people who take time out of their busy day to help you. A great way to do this is to leave a reaction 💙 on the comments or posts that deserve recognition.
Keep up the good work everyone!
-Grant
