GrantSmith Coach

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.

Hi @smitiyadav Is it a matter of the time and data are the same but Domo is just pulling data in 5 hours behind or is it the data appears the same but the times are different? If it's the former it may be because of a delay from the API. If it's the latter it's likely a timezone / UTC issues. Domo expects data to be…

Hi @ravimohan911 Currently I don't believe this is possible. Default page filters are still in Beta and aren't integrated with Domo Embed at this time. That would be good feedback for the beta team though for this specific use case.

Hi @Joe_M Sadly that isn't an option at this point to replace the total number with a hover text value. It will only show the hover text where the mouse is. It's a great idea and I suggest adding it to the Domo Ideas Exchange: https://dojo.domo.com/categories/ideas

Hi @danidiaz Segments are a beta feature right now which allow you to define groups in your dataset based upon certain criteria. "Segments allow you to quickly perform market share analysis and measure one group of data against another. With Segments, you can examine different subsections of your data while still having a…

Your version is close you just need to specify your units (day intervals): select * from `table` where `date` > CURDATE() - INTERVAL 7 DAY DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY) and CURDATE() - INTERVAL 7 DAY are functionally the same. Also CURDATE and CURRENT_DATE are the same, they just have different names.

Hi @Jessica , Currently this option isn't available but it'd be a great post for the Idea Exchange: https://dojo.domo.com/categories/ideas

I don’t think the email download would work in this case as it can’t find the link on the page. Are there other ways to get the data? Do they have an API?

Domo documentation is lacking in this aspect. I'd recommend you get in touch with your CSM to see if they can assist or get their development team to help.

Whomever is logged into the workbench server first gets the updates, any other users don't but will see the message you're seeing. You'd need to kill the other workbench processes owned by the other users (either by asking the other users or killing it in Task Manager) and then restart your workbench program to then get…

Hi @MikeMiller, Are you utilizing Single Sign-On (SSO) for your authentication or are you doing Direct Sign-On?