GrantSmith Coach

@user000253 Similar to your existing beast mode: CASE WHEN CEILING(`Process Temperature (DegC)`)<= 0 THEN 1 WHEN CEILING(`Process Temperature (DegC)`)<= 20 THEN 2 WHEN CEILING(`Process Temperature (DegC)`)<= 40 THEN 3 WHEN CEILING(`Process Temperature (DegC)`)<= 60 THEN 4 WHEN CEILING(`Process Temperature (DegC)`)<= 80…

Hi @user000253 This is because your bins are being sorted based on alphabetical sorting instead of numerical sorting (It's comparing each number one at a time in your value instead of the entire number). When I have bins like this I'll utilize a new beast mode which is similar to the original beast mode I used to create…

Hi @Joe_M I'm a big fan of DataSet Views. They allow for simple ETL operations (aggregation, filtering, joining - even calculated fields) and load in real time as they don't have to send the data off to be processed so they're typically much quicker. Another nice feature is that you can use them in ETL 2.0 dataflows so if…

Alternatively you can utilize an ETL to do the pivot for you as well. Assuming your data is in the format of: Date | Item Status | Count Field you can utilize a group by field and group by Date and Item Status taking the SUM of the count field (or alternatively if you have the raw data do a Count of that field). then toss…

Hi @enricopirazzini It doesn't appear there's a way to pull the audience network information with the currently available connectors. You might want to reach out to your CSM to discuss if they can enable the Facebook Audience Network Connector for you or if it's actually available.

The ETL would be more accurate and flexible in terms of how far back your last value occurred whereas the beast mode would only go back as far as you have defined.

The code above is for a beast mode. If you want to do it in an ETL, you'd need to use two separate tiles to add a constant called join column, set them to 1. Add a filter to one of those Add Constant tiles to filter out any records with a 0 value, then LEFT join those two together with a join tile (your main dataset on the…

Hi @rachelchorlton There's not a simple way to do this with a beast mode. You'd need to do this within your ETL to get the most recent non-0 number in your dataset. You could sort of hack a solution together using case statements and the LAG window function however you'd be restricted to the number of rows back you'd be…

One thing to note, window functions aren't available out of the box, you need to talk with your CSM to get them enabled in your instance.

Hi @Sam1 Sounds like you want an average across the entire dataset to compare against. You can utilize a window function to get this and then compare your average to to it. Overall percentage: SUM(SUM(`UniqueOpens`)) OVER () / SUM(SUM(`NumberDelivered`)) OVER () Putting it all together: CASE WHEN…

@trangnguyen You can utilize the Domo Governance Datasets (specifically Cards) and build a filter card based on the card names where you can serach based on test in the names of those cards.

Hi @Nick_Bertz Currently this isn’t possible to have a default radio button selected and filter the entire page. I think it is something that's on the roadmap to get implemented but who knows when that will be. I'd recommend adding it as an idea to the Idea Exchange. There was one submitted earlier to the Idea Exchange but…

It's how sorting works. The way to get around it is to make sure you have a record for every date and text combination in your dataset.

Hi @user12621 I believe what's going on is because you're missing data within some of your pivot table those values aren't included in the initial sort based on the date. For example: 1/1 A 50 1/2 A 100 1/2 Z 25 You're sorting on the date first so you'd have 1/1 come before 1/2. Since Z doesn't exist for 1/2 it pulls A…

@MarkSnodgrass, Federated datasets can't be utilized in an ETL. https://domohelp.domo.com/hc/en-us/articles/360042932974-Using-the-Federated-Data-Solution#1.2. @user095459 There shouldn't be much of a performance hit from a Domo standpoint. Do you have access to your database logs to see if your server is able to handle…

Hi @user00287 You need to have the Domo Everywhere add-on. Talk with your CSM as it's a premium feature.

Hi @faisalnjit You can use the Beast Mode Manager to copy beast modes. It's under the Data menu and looks like a face on the left hand side.

Hi @sherrysin Due to the security model that Domo implements everything needs to be shared with other users. This is so someone doesn't accidentally get permission to something they shouldn't. You'll have to share your objects with other users. I would recommend using groups to simplify the process so you can share it with…

Hi @nshively There isn't a great way to link filters together except for using a beast mode and defining your conditions like you're doing. You just need an additional condition in your case statement and change your default value: CASE WHEN `Activity Type` = 'sequence' AND `State`= 'finished' THEN 1 -- You could exclude…

Hi @Pallavi Summary numbers must be aggregated so you'd need something like: CONCAT('Q1', SUM(CASE WHEN QUARTER(`date`)=1 THEN `value` ELSE 0 END), ' Q2', SUM(CASE WHEN QUARTER(`date`)=1 THEN `value` ELSE 0 END)) This is under the assumption you're only viewing a single year at a time otherwise multiple years will get…

You can utilize pfilters as GET parameters to filter your data when linking to another page or card. (You could link to different versions of the cards for each different department with a custom SVG for just that department) I don't believe it supports anchor tags in SVG paths.…

Hi @mahmoudfahmy The drill path card can only be a single type of chart. There isn't a way to conditionally display a different card in a drill path depending on what was initially selected.

Hi @user02319 The ds_get method doesn't exist on the Domo object. You need to access the datasets child object and then call get on your datasets. from pydomo import Domo clid = 'XXXX' secret = 'XXXX' domo = Domo(clid, secret, api_host='api.domo.com') ad = domo.datasets.get('XXXX') ad There are some examples on the github…

@user069636 That post was from a presentation that I gave for the Domo IDEAs conference. If you're interested the entire session can be found here: https://www.youtube.com/watch?v=gO8OLpsAk4M

@MarkSnodgrass beat me to it. Had it all typed up and then had to go to a meeting and forgot to post it. Next time @MarkSnodgrass ...

Hi @ninagonzalez Typically joins are going to be case sensitive. https://domohelp.domo.com/hc/en-us/articles/360043427733-Magic-ETL-Tiles-Combine-Data#3. https://domohelp.domo.com/hc/en-us/articles/360044876194-Magic-ETL-v2-Tiles-Combine-Data-Beta-#3.

Hi @user026996 If appears this is a limitation of the Vimeo API. Domo is just calling the publicly available APIs. Looking at their documentation there isn't an option to get the data you're requesting.

Hi @pangeran_zuko If you don't want the groups have you removed the partitions from your window function to get a total across your entire dataset? Or if you're wanting to calculate a total within a group with multiple criteria have you added those additional fields in the partition clause? What specifically do you mean by…

@ahackett I'd recommend using a scripting language like Python (with the beautiful soup package). You could possibly utilize an ETL with some regular expressions but there's much more flexibility and power with a scripting language than you would have with Domo.

Hi @user041053 Domo currently doesn't support a direct connection for Google Ads anymore. Your options are to utilize BigQuery and have google ingest your Google Ad data there and then pull it in or utilize a Google Sheet to pull in the dataset. I wasn't a fan of either (didn't have BigQuery and there were some timing…