Best Of
Re: DOMO QA Dashboard
@JasonAltenburg Data breakage in that, sometimes adobe stops sending data to domo and depending on the dashboards, it might not be caught for days, weeks, even months. I am looking to create a dashboard with a set of cards, that i can say check every week or day to see when there is a data gap between data warehouse, Recurring and Master.
But i see "For data gaps, you could utilize group by and count in MagicETL to ensure that you have matching row counts for the granularity needed between the master and recurring datasets. In other words, you could count previous hour/day in your recurring and compare row count to your master for that hour/day" as a great idea.
Thanks,
Pellogat
Re: Parameter Filer
Yep, so basically you would join your data 1=1 so that it looks like this:
Then in your card you have your two values:
`data` and `comparison data`
Users select a year and a comparison year and the data for each will be displayed. I would suggest setting default values for each, for example: 2022 vs 2023 and then from there allow users to change the dates.
Re: Parameter Filer
@Anna_Yu This sounds like a good use case for Variables. I'd suggest creating two variables to select the years you want to compare. Here are some sample beast modes you could use with these variables:
Year 1 Total:
sum(case when YEAR(`Date`) = `Year 1` then `Amount` else 0 end)
Year 2 Total:
sum(case when YEAR(`Date`) = `Year 2` then `Amount` else 0 end)
Variance:
sum(case when YEAR(`Date`) = `Year 1` then `Amount` else 0 end) - sum(case when YEAR(`Date`) = `Year 2` then `Amount` else 0 end)
% Variance:
(sum(case when YEAR(`Date`) = `Year 1` then `Amount` else 0 end) - sum(case when YEAR(`Date`) = `Year 2` then `Amount` else 0 end)) / sum(case when YEAR(`Date`) = `Year 2` then `Amount` else 0 end)
August 2023 Community Forum Highlights
Hello Domo Community! 👋
August has been a standout month with many new users joining and interacting with the forum. We appreciate everyone’s efforts as you continue to find new and creative solutions to your daily challenges. You put the INTELLIGENCE in BI!
Leader Board's Top 3
Are we really that surprised to see these familiar names on our top 3? Thank you to these exemplary users for answering dozens of questions every month and for being all around amazing! You make our community feel complete.
- @GrantSmith - 773 points
- @colemenwilson - 671 points
- @MichelleH - 316 points
Top 3 Posts
Here are some of the best posts we saw in August. These users had some great questions that were followed up with amazing answers! Follow the links and leave a like for all of your favorites Q’s and A’s.
- Help with a complex calculation that isn't working in Beast Mode. — Domo Community Forum
- Help the Newbie! SQL Connection not working anymore — Domo Community Forum
- DAP Dataflow — Domo Community Forum
Huge shoutout to the following users for asking such great questions and finding even better answers: @Sasha, @MarkSnodgrass, @Jessica, @GrantSmith, @RobB, @trafalger, @colemenwilson, @MichelleH, @Trumpetbob
Top Ideas
The Domo product is always improving because of your ideas. Below are the top voted ideas. Go and give some additional upvotes to the ideas you think deserve to be implemented into Domo.
- New "Domo for Office Add-in" for Excel compatibility with older plugin + having Query functionality — Domo Community Forum
- Customize email address in DataSet via Email Connector — Domo Community Forum
- Freeze top cards (Filter Cards) on a dashboard — Domo Community Forum
- Cookies on Domo Everywhere — Domo Community Forum
Congrats to these users for coming up with innovative ideas: @Pritesh, @colemenwilson, @Kdahl, @joecanning
Newest Contributors
Climbing the ranks is never easy, but these newest contributors certainly made it appear so. Congratulations to our newest Contributors -- we've got our eyes on you.
Newest Coach
Becoming a coach on the forum takes hours of time and effort, which is why @colemenwilson deserves all the praise we can give after hitting coach status in just under two months! Go check out this post about Colemen and show him some love by leaving a comment!
Community Member of the Month
This month’s CMM is someone who came out of nowhere and amazed us with their Domo knowledge and expertise. @DavidChurchman gives detailed answers and lots of them. He clearly understands how Domo works and is sharing that expertise with the community in a big way. With 11 questions solved this month alone, he glided into contributor status and made himself known to the community. Congratulations, David, and keep up the good work!
Give DavidChurchman, and any of the other highlighted users a shout out in the comments below.
Re: Connect DomoStats Across Instances
I use the Dataset Copy Connector to copy the DomoStats datasets from my "child" instances to my "main" instance and then append them together in an ETL in my main instance. That might be a solution for you in the meantime.
