GrantSmith Coach

@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?

Hi @PatM Is your underlying data a numerical value or does it have US$ in front of the values (not displayed on the card but in the raw data)? Is it only in the Summary Number or is it in a table card as well?

Hi @OllieSouthgateAKA In the actual URL in your email (not the clickable link text) - does that have either report or download in the link? When you go to that new page - Does the actual hyperlink on that page link to an actual XLSX file or is it some other type of link? Does that link on the page have either "report" or…

Domo expects data to be imported as UTC. Is it possible to import your data using UTC instead of the local time?

+1

@rahul93 Not currently as it thinks it's already an aggregate.