Best Of
Re: Calculate time between two dates during business hours, excluding holidays & Sat/Sun
How would apply the filter to remove weekend’s
Re: Calculate time between two dates during business hours, excluding holidays & Sat/Sun
Use a formula filter and exclude the dw field in the Calendar dataset where the value is 1 (Sunday) or 7 (Saturday)
`dw` NOT IN (1,7)
Alternatively you can do two filter criteria separately to make sure dw doesn't equal 1 and dw doesn't equal 7.
Re: Calculate time between two dates during business hours, excluding holidays & Sat/Sun
To exclude holidays, if your company follows standard US holidays, you can add the Domo Dimensions Calendar dataset, filter to isHoliday = 1 and then left join your main table to this dataset and then filter out any entries where there is a match.
If your company has a different set of holidays, you would need to upload that list and follow the rest of the steps.
Hope that makes sense.
Re: January 2024 Community Forum Highlights
Congratulations @Ashleigh - We are thankful to have you part of this vibrant space.
Re: Hello from a new user!
Welcome Alex! I am DEFINITELY checking out iNaturalist, that seems amazing!
Re: Group By "Concat Distinct" Now Live!
Thanks for the information. I could have used this ability as a solution to a question I asked last week.
January 2024 Community Forum Highlights
2024 is starting strong with an amazing first month for the Domo Community! It’s time to recognize the amazing contributions you all made and celebrate some outstanding individuals. Over 120 questions received answers, and the average response time was 25 minutes. Thank you all for continuing to solidify the legacy of this remarkable community!
Announcements
Save the date for our next community event! It’ll be a Domo Demo Slam competition between our fiercest community coaches. Come show your support and bear witness to some of the Domo Community’s greatest minds at work. Click here to register for the showdown event on February 22nd @12:30pm ET.
Also, in case you missed it, we had an amazing community meetup last month about Workflows. Click here to learn from one of Domo’s very own how to make Domo Workflows work for you!
Leaderboard Top 3
We have some incredible talent here in the Domo Community, and you never cease to amaze us with your ability to provide quick and accurate answers. These three legends collectively answered over 80 questions. That’s more than half of the questions that were asked last month! The Domo Community thanks you for consistently raising the bar for what greatness looks like.
- @GrantSmith: 732 points
- @ColemenWilson: 534 points
- @MarkSnodgrass: 244 points
Top 3 Posts
Of the many discussions happening each day, these ones stood out as some of the best. Follow the links and show these community members some love by leaving them a reaction.
- beast mode calculation
- Average Calculation less than Trend Points during time period
- Calculate correlation coefficient in beastmode? Do not want to use correlation chart.
Huge shoutout to the following community members for asking such great questions and finding even better answers: @ColemenWilson, @pauljames, @DavidChurchman, @jtrollinger, @MichelleH, @Ashleigh, @Abe, @ST_-Superman-_, @ArborRose
Top 3 Ideas
The Domo product is always improving because of your ideas. Below are the ones that got the most votes. Click the links below and give these ideas additional upvotes to increase their chances of getting implemented into Domo.
- Add option to Trellis/Tiered Date Settings to continue cumulative totals
- Maintain tile position when copy and pasting Magic ETL tiles
- Card-based Alerts Email Notifications: Add direct link to card
Congrats to these community members for coming up with innovative ideas: @jessdoe, @JasonAltenburg, @Craig_Lynch
Community Member of the Month (CMM)
Our CMM is someone who always shows up for the community when we need it the most. She certainly has quite a reputation, having been a community member for almost four years now. @Ashleigh is one of our OG coaches on the forum and has a knack for answering questions with a level of detail that shows just how knowledgeable she is in Domo. In January she participated in 19 discussions and received best answer for 12 questions. We can’t thank her enough for her constant support of the community!
Group By "Concat Distinct" Now Live!
I wanted to make a quick post to let you know about an update we made to the Group By tile in Magic.
In your instances, you should now see the ability to choose a new options when defining how a column should be aggregated in the Group By tile:
- Combine distinct strings separated by ,
This allows you to create an aggregate column that includes a list of distinct values rather than having to choose just the first/last value, a count of items in the aggregation, or a non-distinct list of values.
(Note: The equivalent in an expression/formula would be GROUP_CONCAT(DISTINCT argument SEPARATOR ', '))
While relatively minor, we think this change will make using Group By in Magic just a little bit nicer.
Let me know if you have any questions or thoughts.
Thanks!
Andrea (your friendly neighborhood Magic Product Manager)
Re: Calculating a % based on multiple dates
You could add a case statement
Case when curdate() > End Date then 1 else … end
where the … is your formula from above
