BlueRooster Domo Employee

You could create try something like this: CASE WHEN ((`Year` * 12) + `Month`) > 0 AND ((`Year` * 12) + `Month`) <= 12 THEN '0 - 12 Months' WHEN ((`Year` * 12) + `Month`) > 12 AND ((`Year` * 12) + `Month`) <= 24 THEN '13 - 24 Months' WHEN ((`Year` * 12) + `Month`) > 24 AND ((`Year` * 12) + `Month`) <= 36 THEN '25 - 36…

@jlazerus If you want 0 when only null or blanks are present you can do try this: CASE WHEN COUNT (DISTINCT (CASE WHEN `System Name` IS NOT NULL AND `System Name` <> '' THEN `System Name` END)) > 0 THEN COUNT (DISTINCT (CASE WHEN `System Name` IS NOT NULL AND `System Name` <> '' THEN `System Name` END)) ELSE 0 END

If you also want a distinct count to include nulls then you'll add this: COUNT (DISTINCT (CASE WHEN `System Name` IS NOT NULL AND `System Name` <> '' THEN `System Name` ELSE 'Blank' END)) If there are no valid system names found (only blank or null) your count returned should be 1.

@jlazerus If I understand what you're trying to do, you want to get a distinct count of all none Null or blank values found? If so you can try this: COUNT (DISTINCT (CASE WHEN `System Name` IS NOT NULL AND `System Name` <> '' THEN `System Name` END)) Hope that helps, ValiantSpur

We reached out to our account manager and they were able to get someone to remove this for our basic users. Hopefully the same will work for you.

Under the Chart Properties -> Legend section you'll want to set 'Display in Legend' to 'Value' You'll also want to go to the Hover Legend and check the 'Hide Percent Value' box. That should be all you need. Let me know if you have any other questions, ValiantSpur **Please mark "Accept as Solution" if this post solves your…

If you have a column for years and a separate one for months, you could create a BeastMode at the card level that went something like this: (`Year` * 12) + `Month` That would give you a total count of months for the row in question. Let me know if you have any other questions on how to do this. Sincerely, ValiantSpur

If you follow what I mentioned above and you can set the date filter to whatever timeframe you want and it will roll with the dates as they change (ie, Last 6 Months). Let me know if you need more detail

Something we did so that you could leave the functionality of the date filter for the user was to select all values for each date field and union them while creating 2 new columns, UnifiedDate and DateType. It might look something like this for you: SELECT *, `hire_date` AS 'Unified_Date', 'Hired' AS 'DateType' FROM…

Same errors here. Trying to rerun the dataflows now. :(

If you were to use a SQL transform it would look something like this: SELECT `User ID`, CASE WHEN SUM(CASE WHEN Week(`Date`) = Week(Curdate()) AND Year(`Date`) = Year(Curdate()) THEN 1 ELSE 0 END) >= 1 THEN 1 ELSE 0 END AS 'Current Week', CASE WHEN SUM(CASE WHEN Week(`Date`) = Week(DATE_SUB(Curdate(), INTERVAL 1 Week)) AND…

So if you have the following columns of data: Categories Value Target You could accomplish your goal by splitting the Value field into two different BeastModes: 'Below' CASE WHEN `Value` < `Target` THEN `Value` END 'At or Above' CASE WHEN `Value` >= `Target` THEN `Value` END Now set the `Categories` field to your 'Names'…

You could do something like this: CASE WHEN `Date` >= DATE_SUB(DATE_FORMAT(curdate(), '%Y-01-01'), INTERVAL 1 YEAR) AND `Date` <= DATE_SUB(curdate(), INTERVAL 1 YEAR) THEN `Revenue` END This would return the revenue when it was between Jan 1 last year and current day last year. Let me know if you need anything else,…

Ok, so the more I dug into this the nastier it got. But, there is a way to do it. I found a walkthrough where a guy put together a MySQL formula for this. You'll need to find the Lat/Long values for each zip code you're wanting to use. You can then use those with this Haversine formula: set @orig_lat=122.4058; set…

Are you looking for driving distance or as the crow flies?

What up Scott! So you basically need some way to add a data point for the missing dates to your data source (Without a date and 0 value the linear regression formula is ran for N-2 essentially) You could left join a list of calendar dates to your source data and fill in the nulls with 0. Once you have a reference point for…

Ok, so to do that you'll need to break your `value` column into two separate columns like below: Below Target BeastMode: CASE WHEN `value` < `target` THEN `value` END Above Target BeastMode: CASE WHEN `value` >= `target` THEN `value` END Now use one of those in your 'Actual Value' field and the other in your 'Range 1…

Great tips, thanks Lauren

You could try something like this: SELECT `CompanyName`, MIN(`Datestamp`) AS 'DateStamp' FROM dataset GROUP BY `CompanyName` That would leave you with a single entry for each unique CompanyName and the earliest date value associated with it. Is that what you're looking for, or am I missing something? Sincerely, ValiantSpur…

So since you're wanting to show 'by day', a beastmode won't be the way to go on this one. A beastmode will only look at the rows falling into whatever grouping you define, in this case daily. What you'll need is a new data transform that will return these users for you. Based on some of the fields you're using, a MySQL…

So both the Analyzer (Alchemy Bottle) and Edit in Analyzer take you to the same place. What you can do though is apply filters to an existing card while viewing it, and then you can click the wrench and "Save As". If you have filters applied when you "Save As" the filters you've applied will be maintained in the new copy.…

I'm fairly certain the calendar type card doesn't support html colors. The <br> will work in breaking your hover text, but the actual color options for the dates can only be set using the theme options and you can't change the color of the hover box to my knowledge. Let me know if you have any other questions, ValiantSpur…

The only thing I could think of would be that the other admins would need to be reduced to something like Privileged instead of Admin. I know there was some discussion about segmenting business units at Domopalooza, but I think that would still be a ways off. Let me know if you have any additional questions on this and I…

Are there any inconsistencies in the names that you're aware? (Is it possible you have leading or trailing spaces?) The other thing you could try would be this: CASE WHEN `Company Name` LIKE '%COGNIZANT%' OR `Company Name` LIKE '%AARP%' THEN 1 ELSE 0 END Hope this helps, ValiantSpur **Please mark "Accept as Solution" if…

If I'm understanding you correctly, you're setting the column type for both columns and then attempting to join, is that correct? Could you give some more detail around the error you're seeing? Sincerely, ValiantSpur 

Unfortunately there's no way to hide the Card Title that I'm aware of. I could definitely see the benefit of this though, especially on the doc card. It may be worth posting this as an idea in the Ideas Exchange. If we can get a few upvotes for it, it'll be reviewed by a product manager. You can suggest an idea here:…

Currently no you cannot add color to a Sumo card. However, they are making strides in bridging the gap between the table card and the sumo card soon. Perhaps this is something that will be hopefully be included in that. Sincerely, ValiantSpur

Unfortunately, I do not know of a way to move the X axis label from the bottom to the top of the card. If it's something you think others may find useful, you can submit it as an idea in the ideas exchange here: https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas Sincerely, ValiantSpur

It sounds like you're almost there. Here's what I did, maybe that will help bring your across the finish line. I created a "Working Day" calendar that's just a list of dates (from like 2000-2200) and the "WorkingDayOfMonth" for each date. I then take my dataset I'm working with and Left Join it to the Working Day calendar…

Adam, Not sure if this is why, but it is possible for you to have access to the original dataset being used and then the drilldowns to utilize a different dataset that you might not have edit permissions to. Might be worth looking into. Sincerely, ValiantSpur