Best Of
Re: Compare to Industry Trends
You could normalize the data:
Or just divide by a thousand, or ten thousand and then use a chart type that allows for multiple axis labels (left and right) and be sure to label the axis that has been adjusted to read "In thousands" for example.
Product Release 07.22.2024
Domo just got better. We're constantly working to make quality-of-life improvements, bring new features, and add new integrations and connections to make Domo an even bigger asset for YOU.
We're excited to announce our latest batch of updates. Here are five of our favorites:
🧠 DomoGPT | A suite of Domo-Cloud private models that safeguards your sensitive data within Domo’s secure ecosystem.
🔎 Analyzer Improvements | Context Sensitive Chart Properties, enhanced input checking + validation for numbers, & more to streamline chart building.
📈 Deploy Externally-Hosted Models in Magic ETL | Integrate any eligible externally-hosted model into Magic ETL to accelerate data prep and insight generation—making AI more accessible to all.
☁️ DataFlow Sharing Modal | Sharing a DataFlow is now as simple as sharing a data set!
↗️ Persistent App Studio Filters | Set filters for specific columns or all columns in a dataset and apply them across your entire app.
See what else we added and what it all does on the New Features page and read up on the latest release notes.
Re: 350-501 SPCOR exam passed
Thank you for sharing your inspiring journey! It's great to hear how you overcame challenges and found direction through the Cisco 350-501 SPCOR certification. Your experience with Pass4Success's practice tests sounds really encouraging, and I'm sure it will motivate others to take the plunge. Congratulations on your success and for achieving such excellent grades.
Re: GA4 Connection Question
Hi @Sonia_4268 ,
Yep that looks right. You can also do Rolling Window and do Relative 365 days or 730 days or whatever you want. I do 730 because even though there is no data for 2 years ago I don't want the dataset to grow forever. I need to make a GA4 Connector video, but this one is for the older GA advanced connector:
Re: Alert set up
Something like this. Obviously I just chose something random, but this is how you create a filtered alert on a dataset.
Who wants early access to a bigger Magic ETL canvas?
Hi friends!
We recently finished the code to quadruple the Magic ETL canvas size (double the width, double the height). This will be going out to everybody soon, but we wanted to give some of you early access and let you play around with it before we turned it on across the board.
Email me with your instance URL if you want early access to the larger canvas! 🙋♀️ (andrea.henderson@domo.com)
Re: Snap to Grid functionality in Magic ETL
Since the last Domo shadow update, the previous ETL grid overlay has stopped working. I'm currently working on a fix.
skouzini
Re: Domo Group Help: Navigating to Score Components in Domo
There are a lot of approaches you could use to do this. I can't tell what level of aggregation you'd like, so if all you're looking for is just overall proficiency by subject, you could create a handful of summary number cards that averages each of those.
If you want the ability to summarize by different levels of aggregation (average by demographic group, by school, by school level, etc.), then an approach I like it using two variables, one that controls the metric to be displayed and the other to control the aggregation level. With those two controls, I really only need a couple cards, and the user can still slice the data in dozens of different ways. Your metric variable could allow them to switch between "overall" and different "subject level" performance measures.
Here's a few snips of that approach, showing the different options.
Re: Analyzer Subtotals
Yes. In analyzer view, click the v and then check "Hide subtotal" as shown below:
Re: I have the following code and works but I want to SUM as is I get 3 values
@Absher_645 You will need break your calculation into two separate case statements surrounded by a count distinct, one for positive values and one for negative values:
count(DISTINCT case when `OrderReason` in ('New Service','New Account') then `AccountCode` end)
-
count(DISTINCT case when `OrderReason` = 'Disconnect' then `AccountCode` end)
