Best Of
Re: How can I add week ending dates when I have only days of the week?
@ColemenWilson I'm not smart enough for that fancy math. I have to use fingers and toes.
Re: JUNE in for the latest Community buzz 🐝
Thank you everyone! It is great to be part of such an engaged and supportive community! It helped me immensely when I first started using Domo, and I enjoy being able to give back to others who are just starting out.
JUNE in for the latest Community buzz 🐝
Exciting news! Community members of the month and top 3 leaderboard winners will now earn gift cards. Congrats to @MarkSnodgrass, @ArborRose, and @ColemenWilson for being the first to reap the rewards 🥳
Keep reading the top discussions, ideas and more from June below.
🔥 Most Active Discussions in June
These conversations sparked the most engagement—be sure to check them out and chime in with a reaction or comment:
- Description field in activity log
- Month formula for month to month change
- Beast Mode Calculation
- Incline table card
@ColemenWilson and @ArborRose answered all of these questions! Thank you for your contributions as well, @DavidChurchman. @kim_barragan0126, @Utz, and @art_in_sky, your questions seem to have resonated with the rest of the community too. 50+ views on all of these posts.
Leaderboard Top 3
Thank you @ArborRose @MarkSnodgrass @ColemenWilson for helping community members live-answer their questions. Every answer helps future users too. The Forums get millions of page views and thousands of searching each year. Watch your inboxes for a gift card from Domo!
- @ArborRose, 349 points
- @MarkSnodgrass, 190 points
- @ColemenWilson, 149 points
Top Posts
Here the most viewed and engaged posts from June. Follow the links and leave a reaction if you found them helpful too!
- More Efficient YoY actual than budget view
- Best practice for visual indication that a drill down configured
- Showing profile photo on Sales leaderboard
- Why date filter is not working
- Error fetching results from DomoAI textual analysis app
- Beast Mode for total active tickets per hour
- Smart text date ranges
Shoutout to the following community members for asking and answering our top discussions this month: @Data_Devon @DavidChurchman @GrantSmith @Jay.p @MichelleH @nathankilcrease @amberd @BryantCafferty @ellibot @ArborRose @Abe @Thuy_Tu @JoeS
Top Ideas
These two ideas tie for the most upvoted in June.
- Collapse the bottom section of the Formula editor window, 11 upvotes
- Magic ETL join visual feedback, 11 upvotes
Thank you @Sam_Donabedian and @Craig_Lynch for sharing your innovative ideas.
New Rank-ups
@garetthansen, Contributor
@erikjamesmason, Contributor
@SayyedHussain, Contributor
@lhrogersiv, Contributor
We see all your engagements that led you to ranking up… thank you for all your contributions!
Community Member of the Month, @MarkSnodgrass
@MarkSnodgrass has been a KEY member of the Domo community for 6 years now. He's accumulated 13.5K reputation points on the Community and currently sits at #2 all-time on the leaderboard. He's consistently been on the monthly leaderboard for years. Leave a comment below if Mark has been helpful to you and getting your questions asked.
Let's thank and congratulate @MarkSnodgrass in the comments below!
Re: SQL/Beastmode query for copying in values from another column
Thanks so much! I knew I was close to where I wanted to go but wasn't sure how to get there. Much appreciated.
Re: SQL/Beastmode query for copying in values from another column
You are close. It should look like this:
CASE WHEN LeadsData.Medium = 'Further' THEN myothercolumn ELSE LeadsData.Source-Mapped END
You'll need to replace myothercolumn with your actual column that you want to use.
Re: Dayforce data
Looks like the Dayforce Connector uses the following for its API connection:
https://usconfigr57.dayforcehcm.com/{clientNamespace}/V1
If this is outdated, I would send an e-mail to support@domo.com and let them know what the current API call should be. It may take some time for the connector team to update the API calls, though.
You may want to look into the JSON no code connector and see if you can make that work for you. It is a nice universal connector to use.
Re: I need a beast mode that provides 2025 Sales % VS 2025 targets
@CK_16 The error can be resolved by rearranging the calculation so that the numerator and denominator of your beast mode each contain a single case statement within a sum like below.
sum(case when year(`trx_date`) = 2025 then `extended_amount` else 0 end)
/
sum(
case
when `Product Category` like 'Product 1%'
and year(`trx_date`) = year(current_date()) - 1
and dayofyear(`trx_date`) ⇐ dayofyear(current_date())
then `extended_amount`*1.055
when year(`trx_date`) = year(current_date()) - 1
and dayofyear(`trx_date`) ⇐ dayofyear(current_date())
then `extended_amount`*1.145
else 0
end)
Re: How can we get the current date/time to be used within a Workflow?
That's a great way to handle it. You can also find a function in the Workflow Executions package that will give you metadata about the workflow.
I know the team has "system variables" on the roadmap, where some of these things will just be automatically there as variables that can be used…stuff like who started it, when, etc… There's also plans to expose syntax for things like current date right in string builder.
Re: Scheduled Report - Excel Attachement
@Jones01 That is correct. I am able to receive card-based scheduled reports as an .XLSX file, keeping all of the UTF-8 characters. I don't have an option to choose XLSX or CSV. It sends an XLSX file for all card-based scheduled reports.
