GrantSmith Coach

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…

@user06963 There is a beta which allows for filtering on aggregates. You can start a conversation with your CSM to see about getting into the beta.

Have you put your beast mode into the sort section of your card to sort based on the rank? That'll put the ones that are blank at the bottom (you may need to revert back to your old beast mode).

Hi @user069636 Are you doing any sorting on your card? Would filtering out records with NULLs in your card work for you? Are you just not wanting a rank if the value is null? If that's the case you could do something like: CASE WHEN `field` IS NOT NULL THEN RANK() OVER (ORDER BY `field` ASC) END

Hi @Sam1 There actually is a forum for beta features - https://dojo.domo.com/categories/beta-group. You may not have access and might want to reach out to @chucki

Thanks for updating the ticket with your resolution. It will help others with your issue (and even those without) searching through the Dojo.

Hi @Neko It's not currently possible as you can't conditionally set a bar total based on the bar number and also because how the stacked bar chart interprets your data. I'd recommend submitting an idea for a stacked waterfall graph on the idea exchange: Ideas Exchange

Hi @user16322, When are your alerts scheduled to be fired? Is your data meeting that criteria when attempting to direct it to your Buzz channel? Are the alert settings for the notifications you receive the same as the ones being sent to the Buzz Channel? Have you tried setting up a duplicate alert just like the one you're…

Hi @user048760 What type of join are you doing? Are you doing an inner join? If so, does the specific field you're joining on have the same value in both datasets?

Hi @Mike_Shrift You'll need to get in touch with Domo Support as it's an issue on their end and they'll be able to assist you with a resolution.

If you must use a beast mode one like this should work for your use case: CASE WHEN `dt` >= (CURRENT_DATE - INTERVAL (DAYOFMONTH(CURRENT_DATE) - 1) DAY) - INTERVAL '12' MONTH AND `dt` < (CURRENT_DATE - INTERVAL (DAYOFMONTH(CURRENT_DATE) - 1) DAY) THEN 'Include' ELSE 'Exclude' END I've outlined getting the first day of a…

Hi @Salmas You can just use the date selector on the car to select the last 12 months instead of having to utilize a beast mode: This will give you the most flexibility with your card. You can also configure it in analyzer to select it by default.

Hi @Joe_M This isn’t possible because how PDP works. It filters the data before ever sending it to the visualization layer so you can’t just pick and choose if PDP is applied on a specific visualization.

@user060355 @jaeW_at_Onyx is suggesting you take your data, replace the country column with the 'average' value, then append that back to the original dataset. It'll look something like this: Then you can utilize his beast mode to plot the average instead of the sum for the average amount.

@cthtcc This would be a good question for your CSM as they would have some insight into the product roadmap.

Hi @juanshockoe You'll likely need to talk with Domo Support to get this bug looked at.