Best Of

Re: comapare current-3 days in period over period chart

@chetan_cricut here is what @GrantSmith is suggesting.

From the list of charts, choose Gauges and select Multi-value Columns chart.

In the date range select Previous and Last 4 Days

Create a beast mode called "Last 3 Days" that looks like this:

CASE when date >= DATE_SUB(CURRENT_DATE(), INTERVAL 3 DAY) THEN confirmed_total END

You will need to swap out the date field and the confirmed_total field with the date field in your dataset and the value field that you want to total

Create another beast mode called "Last 4 Days" that looks like this:

CASE when date >= DATE_SUB(CURRENT_DATE(), INTERVAL 4 DAY) THEN confirmed_total END

You will need to swap out the date field and the confirmed_total field with the date field in your dataset and the value field that you want to total

Drag the Last 3 Days field in the Gauge Value field and choose an aggregation type of Sum.

Drag the Last 4 Days field in the Comparison Value field and choose an aggregation type of Sum.

You can then use the Chart Properties to change the look and what values you want displayed.

Hope this helps

MarkSnodgrass

2

Re: Need to calculate the difference between two dates with proper date format

You can use the SPLIT_PART function and CONCAT function to build this. It would look something like this:

CONCAT(

split_part(Time,' ',1),' days ',

RIGHT(split_part(Time,':',1),2),' hours ',

split_part(Time,':',2),' minutes ',

split_part(split_part(Time,':',3),'.',1),' seconds '

)

You would need to add additional case logic if you didn't want the days to show if there were no days.

Hope this helps.

MarkSnodgrass

1

Re: Need to see which connectors are currently connecting

Its not a dashboard solution but one feature I always overlook is the data warehouse tab in the datacenter. It is very easy to see all connectors and what is having issues, its also super ways to rerun things right from there instead of having to go directly to the dataset.

Ashleigh

3

Re: Connecting to domo.js in React app not working

Just wanted to post back here that my issue has been resolved.

Apparently, I had everything setup correctly but I was not importing domo correctly into the app. I had the import set as import { domo } from 'ryuu.js'; , which was failing to recognize it. I didn't know that domo was exported as default so it should have been import domo from 'ryuu.js'; (without the curly braces). Once I included that import correctly, the connection to domo worked.

Thanks for the responses.

Tony

btp_tlangston

2

Re: How to stop a dashboard's background change from impacting charts

I see what you mean in the series for the non-hovered bars in the series. I would start with a support ticket and see if they acknowledge it as a bug. If you don't have any luck with that, I would submit it as an enhancement in the Ideas Exchange and see if it gets incorporated into the future.

Glad you are enjoying my videos and thanks for becoming a subscriber!

MarkSnodgrass

2

Re: Need to see which connectors are currently connecting

This can be done a few different ways.

"DataSets History" report in Domostats. Has the full history for all connectors including:
1. Run status
2. Execution Type
3. Number of API calls
4. Updated Rows
5. Even Bytes inserted
If you don't need that much detail or a full history, you can use the "Datasets report" in Domostats which will return the most recent data for each connector:
1. Last run date
2. Run status
3. Import type
4. Etc…
Domo Governance "datasets" report
1. really similar to the "datasets report" from Domostats above.

ColemenWilson

2

Re: June Domo Community Forum Spotlight

Wow I'm honored! Thanks @GrantStowell ! I don't get to dig into the weeds as much in my current role as I used to, so the forums are a great way for me to stay sharp and also keep learning new things. I've been having a great time solving users issues. Next milestone: coach status!

ColemenWilson

6

June Domo Community Forum Spotlight

Hello Domo Community!

We hope you enjoyed June as much as we did! It was a standout month with many notable community achievements. We would like to highlight some of the outstanding efforts made by some exceptional community members who are going above and beyond in supporting their peers.

Leader Board's Top 3

These individuals have blown us away with the speed and accuracy of their responses. Not only did they respond to the most questions, but they had multiple back and forth conversations with users trying to hash out viable solutions to their challenges. To say they went the extra mile is an understatement. Bravo 👏👏👏

@GrantSmith- 758 points
@MichelleH- 558 points
@colemenwilson- 448 points

Top 3 Posts

With the many discussions happening each day, these ones stood out. Follow the links and show these users some love by leaving them a reaction.

Huge shoutout to the following users for asking such great questions and finding even better answers: @muahmmad_zaidi, @Lauren_Kerl1, @Aag2023, @MarkSnodgrass, @trafalger, @MichelleH, @GrantSmith, @colemenwilson.

Top 3 Ideas

The Domo product is always improving because of your ideas. Below are the top voted ideas (we had a four-way tie for 3rd place). Go ahead and give some additional upvotes to the ideas you think deserve to be implemented into Domo.

Congrats to these users for coming up with innovative ideas: @mlhancock, @SlickVic, @MichelleH, @rockchalk629, @user084060, @Samuel.

Newest Contributors

Climbing the ranks is never easy, but these users certainly made it appear so. Congratulations to our newest Contributors -- we've got our eyes on you.

Community Member of the Month

When selecting the CMM for June, there was one clear winner. @colemenwilson climbed faster than anyone we've seen -- he went from Member to Contributor in a matter of just a couple of weeks. In one month, he made over 60 comments and racked up an astounding 448 points. If you asked a question on the forum, chances are pretty high that colemenwilson was there with an answer. Huge shoutout and a round of applause! 🎉👏👏👏🎉

Help us recognize your peers by leaving a comment below!

GrantStowell

7

Re: Calculate the average normalized score in Beast Mode

The FIXED function can be used to get the MAX score on a product basis:

MAX(MAX(Total Skill Score) FIXED(BY Product))

The normalized Score could be calculated as

Total Skill Score/MAX(MAX(Total Skill Score) FIXED(BY Product))

I'm concerned you're trying to get data at multiple aggregation levels and if you want to do that on a single chart this will be really complex, up to point 5 you're running this by employee, but then you want to run this by Product Group. All this sound doable with the FIXED formula as a Beast Mode, should it be responsive to filters applied to the card, if you want the MAX to be always from the full dataset, then I'd suggest you go with an ETL that will use a Group By Tile and Joins to add the Max Product Score and Max Product Group Score as additional columns to the dataset so you can operate with them with easier formulas once working on the cards themselves.