Best Of
Re: Calculating Attach Rate - when product B is on a transaction that also has product A
Thanks Sean. I had tried something similar to what you tried with a beast mode, but was not quite getting the results. I definitely need it to not have the ID in the card as I need to show the overall Attach Rate.
I'm think I'm going to have to go the ETL route.
Thank again for having a go.
Re: Monthly Reports (Google Sheet). Help with next steps.
Thanks for sharing this post is helpful for me too.
somit
Re: Are PPT exports and Domo plugin visuals static?
You’re correct that standard PPT exports and the Domo plugin for PowerPoint are generally static. The Domo PowerPoint plugin itself does not support real-time updates. Once you insert a chart or a report into PowerPoint using the plugin, it does not automatically refresh the data. You would need to manually update the data by re-inserting the content from Domo.
You might consider Power BI integration or Domo API integration? Such as using Domo's REST API to fetch data from Domo and up date PowerPoint files programmatically.
Fetch from domo….
fetch('https://api.domo.com/v1/datasets/{dataset_id}/data', {
method: 'GET',
headers: {
'Authorization': 'Bearer YOUR_ACCESS_TOKEN',
'Content-Type': 'application/json'
}
})
.then(response => response.json())
.then(data => {
// Process the data
});
Update PowerPoint…
let pptx = new PptxGenJS();
let slide = pptx.addSlide();
slide.addText('Updated Chart Data', { x: 1, y: 1, fontSize: 18, color: '000000' });
// Add your chart or table data
pptx.writeFile('UpdatedChart.pptx');
How to join the Community Forums: Step by Step
Have you been a content consumer instead of creator on the Community Forums? Creating an account is really simple and allows you to engage by asking questions, starting discussions, and collaborating with other users. The Community greatly benefits from each contributing user.
Follow this guide to sign up and get started in the Community Forums.
Re: Limitations of SQL API
There used to be a page, but it appears to have been moved or removed.
https://developer.domo.com/docs/apis/data-apis/sql-api
If you look at the answers to a recent question I posted, you will see that new SQL functionality is right around the corner.
Re: Domo PowerPoint - "Could not render the following cards"
I don't think there is a specified limit. But that doesn't mean you aren't hitting an issue where it's overloading. There are many things that could be affecting it. Network issues, domain vs domain connectivity, permissions, etc. I like your suggestion to have her open a new PowerPoint and try again. Start small and work up to try to eliminate the issue.
June Community Recap
Hello Domo Community!
Happy July! It's time to recap the Community Forums
top moments in June. Follow the discussion, ideas, and user links to contribute to June's hot content 🔥
Forum Frenzy Day
The first of its kind, we launched a Forum Frenzy — one full day where we recruited some Domo's internal experts (support, technical, consultant, education reps) to answer questions in real time. The average time to get an answer on June 26th was 12 minutes! Record breaking. We know many of you took advantage of this day (we saw a 66% increase in discussions this day). But if you missed it, keep your eyes out for another Forum Frenzy this fall.
Leaderboard Top 3
We love seeing the monthly competition. Huge thank you to @ColemenWilson, @david_cunningham, and @ArborRose!
- @ColemenWilson 686 points
- @david_cunningham 479 points
- @ArborRose 356 points
Top 3 Posts
Of the 303 discussions that were had in April, these three got a lot of views and engagement. Follow the links and leave a reaction if you found them helpful too.
- Variable names in string
- Need to update the logic from a previous discussion
- Magic ETL - tile now beyond scroll ability
Shoutout to the following community members for asking and answering our top discussions this month: @LearningNinja @jessdoe @ColemenWilson @ArborRose @shreeb @david_cunningham @Jbrorby
Top 3 Ideas
The Domo product is always improving because of your ideas. Of the 60 ideas posted in May, these three got the most votes. Click the links below and give these ideas additional upvotes to increase their chances of getting implemented into Domo.
Congrats to these community members for coming up with innovative ideas: @WJ_BI @Gio
June Community Member of the Month
@MichelleH shows up on the Community so consistently that she could be Community Member every month! However, this month in particular, despite a weird bug that was blocking Michelle from commenting, she continued to find ways to help others and answer questions. @MichelleH has answered hundreds of questions, made thousands of posts, and received hundreds of positive reactions…. all adding up to 7.5K reputation points. I don't know what we'd do without @MichelleH 's expertise. Thank you for being a key member of our community.
Like this post if you've been enjoying the monthly Community highlights. And make sure to congratulate @MichelleH in the comments below 🥳
Re: How do I flip the x axis on a vertical bar chart?
One thing you could do is to use a tooltip and wrap your value inside ABS() in beast and then display that tooltip. That way the values you display will be positive, but the chart will still be inverted like you are looking for.
Re: How to add month over month and year over year column to data table
Hi @user023295 ,
Another option is to structure your data a little bit differently to give you more flexibility over the differences / comparison periods. There's an outline previously done here: https://dojo.domo.com/t5/Card-Building/Current-Year-Prior-Year-and-Budget-on-Same-Card/m-p/49142
Once you get it configured and setup you'll have multiple records for each date (Current, Last Month, Last Year). You can then utilize beast modes to calculate the period over period differences. For example YoY %:
(SUM(CASE WHEN `Offset` = 'Current' THEN `amt` ELSE 0 END) - SUM(CASE WHEN `Offset` = 'Last Year' THEN `amt` ELSE 0 END)) / SUM(CASE WHEN `Offset` = 'Last Year' THEN `amt` ELSE 0 END)
MoM %:
(SUM(CASE WHEN `Offset` = 'Current' THEN `amt` ELSE 0 END) - SUM(CASE WHEN `Offset` = 'Last Month' THEN `amt` ELSE 0 END)) / SUM(CASE WHEN `Offset` = 'Last Month' THEN `amt` ELSE 0 END)
