BlueRooster Domo Employee

With a case statment, any values not included in the WHEN clauses are set to NULL by default if there is no ELSE included. Example: CASE WHEN `Vendor` = 'XX' THEN 'decimal' END By removing the ELSE, the above would result in only the XX vendor having a `decimal` value while all others are viewed as NULL. If this isn't what…

Here's the only way I've been able to get an alert to trigger without including any number values in the visual, maybe this will get you started in the right direction: 1. Instead of having 1 dataset with your months and Yes or No flag, break it into a new dataflow so that your current dataset populates an "Only Yes"…

Depending on what chart type you're using. You can click on the Value Scale option and you shoud see a Negative Numbers section as shown below. This is where you can choose to have negatives displayed with () instead of - Please let me know if you have any other questions. **Please mark "Accept as Solution" if this post…

Ahh, I see. I'm actually doing PoP using a Line + Grouped Bar. My X-Axis is month names using: MONTHNAME(`Date Field`) Y-Axis is the Variance BeastMode from earlier. And 2 Series fields Previous 12 Months: COUNT(CASE WHEN `Date Field` IS NOT NULL and `Date Field` < DATE_SUB(CURDATE(), interval 12 month) AND `Date Field` >=…

There's an option under the General tab called 'Hide Values' that should do what you're asking, however it appears on testing that it's not actually removing the values as expected. Please let me know if you see the same behavior in your own testing.

I have actually created this card in our environment. It's showing this year by month over last year (same period) I have the variance % trending over each month and the total variance for the year is achieved by having the BeastMode for the variance % set to "Use All Values". As shown below Here's a generalized version of…

One way that you can accomplish this would be by using the date dropdown available for each card when in the Analyzer. Just select the option for "Between" and then specify the date range you want to display. Please see below for refrence: Let me know if you have any questions on this or if this still doesn't satisfy your…

I also wasn't able to find how to do this. It almost looks like a new Peak-to-Peak area fill, but I'm not seeing an easy way to do this. I'll be interested to see if there is a solution. Nice catch

Tiffany, This is done an a per column basis, see the screenshot below: To hide the subtotal for the date column, i can click on the Date field at the top of the visual like so: After choosing Subtotal/Total, and Hide Subtotal, I'm left with the following:

For the fields you want to hide from the subtotal, click on the column name where you added it to the table. Choose "Subtotal/Total" and the click "Hide subtotal".. see below: This will keep it from summing up values that it shouldn't. Let me know if you need any other help. **Please mark "Accept as Solution" if this post…

A couple of things come to mind when trying to recreate the scenario you mentioned. Visually, the only way I can think of to have 2 separate tables would be to create a custom app: https://developer.domo.com/domo-apps/get-started This would be the most work and the clickable functionality might be tricky to code, although…

Josh, We have a similar setup in our environment, department specific pages with pdp based cards. The Overview, Favorites, Alerts and Shared pages are User Specific pages and can't be removed as they are Domo defaults. This gives each user some unique pages for them to maybe favorite some cards or setup their own alerts on…

To get rid of pages you have 2 options. 1. The first is to hide the page. You can do this by first clicking on the new page icon: And from there you can choose the "Hide" option for the page in question: 2. To actually delete the page, click on the waffle button in the top right and go to the Admin section: Once in the…

Unfornately the ETL option limits you to only using Joins. So this would need to be a MySQL transformation in order to do it this way. If you have any issues creating the SQL Data flow, don't hesitate to ask. **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the thumbs up if…

There's a couple of different ways to handle something like this. If all of your data looks like your example, you could import the original dataset and then do a data transform like the one below: SELECT COL1, COL2, COL3 FROM Dataset UNION ALL SELECT COL1, COL2, COL4 FROM Dataset UNION ALL SELECT COL1, COL2, COL5…

Hara, It sounds like the 'last 7 days' may be a better timeframe than current or previous week. To change this, go to the analyzer for the card. On the top right of the card window, you should see a dropdown, where you change between current and previous week, select 'Last' and then choose '7 days' and then 'by Week'. It…

I was just looking at this in my environment and saw the same behavior. However, when looking into it further, the additional cards listed in the dataset are actually due to the additional drilldowns attached to the main card. So Main Card -> Sub Card 1 -> Sub Card 2 are reported as 3 Cards on the dataset view. Not sure if…

If I understand correctly, you're looking for a way to sum the time values within a column that are currently formatted to show dd:hh:mm. I broke it down by converting each section to minutes and then extracting the amount of days, hours and minutes in the final "minute sum". This beast mode seems to work in my testing.…

I believe there are two different ways that you can accomplish this. 1. On the card level, when you first click into a card to view it, you should see the following box in the bottom left. As long as the editor user isn't the owner, this should keep them from making changes. 2. The second option is on the page level. At…

I've confirmed that this behavior happens in both Bubble and Bubble (Legacy) chart versions. Doesn't look like there's a workaround at the moment.