Best Of
Re: Not able to sort Dates
I agree with @Data_Devon about the dates being sorted alphabetically. If you remove the sorting altogether, the card will automatically be sorted chronologically by the date in the X Axis.
Re: Not able to sort Dates
Hi Ritesh! It looks like you have it sorted by Alphabetically even though the X-Axis is a date type.
Click the little "ZA Arrow" sort button on the Y Axis, as shown in my screenshot, to toggle through different sort options. One of the sort options will be by date, as you are intending.
Doing it this way, you won't need the "Sorting" field populated because it'll sort in the card itself.
Let us know if this works,
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.