BlueRooster Domo Employee

How are you wanting to display this? Also, are you wanting to include the 'Last Month' in your 12 month average or is this 12 months prior to your 'Last Month', I'll assume the later. You could try something like this. Last Month Revenue: SUM(CASE WHEN `Date` >= DATE_ADD(LAST_DAY(DATE_SUB(CURRENT_DATE(), INTERVAL 2…

Give this a shot: CONCAT( count(`Have License`) / count(`Total Users`) * 100, '%') Might've been the % was enclosed in ` instead of ' 

Another option instead of a BeastMode would be to use either the Running Total Bar or Line graph. You could then set the date range to graph by day and get the result you're looking for. You can read more about it here:…

To my knowledge there isn't a way to do this as both the Group Total and Series values share the same data label format. I can see the value of this, but right now the only thing close would be to leave the Hover Text Settings to the value of the series so they can be moused over and show the summations instead of…

翻訳を許してください 残念ながら、Dojo内からドキュメントのコンテンツを検索する方法はありません。これは素晴らしいアイデアですが、Idea Exchangeセクションに追加する価値があります。 敬具、 勇敢なロニン

In the last distinct count, if you replace the month with something like this to capture year Concat(Month('Sales'),Year('Sales')) That should allow you to keep your months distinct between years. Let me know if you have any other questions, Valiant_Ronin

Looks like you need to add a ( before your formula. Try this Concat ( (count (`Have License`) / count (`Total Users`) * 100), `%`)

You need to give a name to the new calculated column, like so: select a.* ,(Select count(DISTINCT b.Employee) from `transform_data_9` b where Date_Format(a.date,'%Y-%m-%d') = b.`date` and a.date between b.`End Time` - b.`Start Time` and b.`department` = 'Distro') AS `Number of Distro` from `transform_data_8` a Let me know…

If you're using whole month aggregates, the only method would either be to default the months to always use the first day of the month as in my original suggestion (this would allow you to use a date quick filter). The other option if you don't want days is to leave it as a string with Month/Year and the user would have to…

If you're missing a day, you'll have to add one before using the STR_TO_DATE function. You could try this: STR_TO_DATE(CONCAT('01-',`DateColumn`), '%d-%b-%y') That should convert all month/year strings to a usable date. Let me know if you have any other questions, ValiantSpur **Please mark "Accept as Solution" if this post…

The only way to do that currently would be to have a column that evaluates whether the goal is met and flag something like Yes or No as your data updates. It would need to process on the ETL side the card in order to work. I like the idea you have and there is actually another already out there on the Ideas Exchange here:…

My initial thoughts would be to use the SUBSTRING_INDEX and SUBSTRING functions. Here's some info on SUBSTRING_INDEX https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_substring-index This would allow you to find the 2nd occurance of a delimeter that you define and then you can use that with the…

You're going to need to calculate the start/end dates ahead of time. The simple case when in your examples won't work when used just in the procedure call. You would need something like this: DECLARE @StartDate DateTime = (SELECT MAX(`Date`) FROM table) And I would even put it in the procedure itself, but that's a personal…

I think the issue has to do when using CONCAT, this is converting your time to a text field and so time sorting won't work. You might try creating a second beastmode: TIME(CONCAT(Hour(`contactStart`),':',CASE WHEN MINUTE(`contactStart`)>=30 THEN '30' ELSE '00' END)) And use that in your sorting section. That should order…

What I've done before is create a stored procedure in 1 transform (declaring my variables here) and then Call the procedure in the next transform. Here's an example I keep on hand (You can use the syntax if nothing else, but not the DECLARE statement): CREATE PROCEDURE testProcedure() BEGIN DECLARE i INT DEFAULT 0; WHILE…

It would go something like this: SUM(CASE WHEN `Status` like 'won' THEN `Value` END) / COUNT(CASE WHEN `Status` like 'won' THEN `Value` END) Let me know if you need anything else, ValiantSpur

Sure! All you have to do is wrap the Number column in a Concat statement. Like this: CONCAT(`Number`) That should be all you need. Let me know if you have any issues, ValiantSpur

It looks like the link you're providing is directly for a card instead of a page. the /kpis/details/xxxxxxx need to be removed so that you only link to the page and not to the card. I've tried myself to get it to filter directly on a card but no luck. If someone else has been able to find a method of direct card fitlering,…

I do know that dynamic drill paths are something currently being worked on (but not ready yet). Currently the only way I can think of accomplishing this is to use Page Analyzer Links that chooses a different link based on which series it being used. You would also need to use a table card instead. Here's a link to info on…

Year to Date and Current Year should return the same as they're the same time period. Moving Annual and Moving Quarterly can be done by choosing Last 12 Months (or Last 4 Quarters or Last 1 Year or Last 365 Days), same for moving quarterly. There are many ways to return the same time period. If you want the last completed…

So I believe the only way you could pull this off would be to create a SQL transform to first group your data and add a previous day volume column. You could accomplish this with the following two transforms: SELECT CAST(`Timestamp` AS DATE) AS 'Day', AVG(`Fluid Volume`) AS 'Avg Volume' FROm testingdata GROUP BY…

Ok so if you've got the dataset described and you're wanting to show 3 different column names along the X axis, then you'll need to modify your original dataset so that all 3 column names can be found within a single column of data. Using a SQL transform you could do something like this: SELECT `col 1` AS 'Value', 'col 1'…

It might go something like this: CASE WHEN `URL` like '%blah%' AND `amount` > 0 THEN `amount` WHEN `URL` NOT LIKE '%blah%' AND `amount` > 0 THEN `amount` END Is the '-' an actual dash or is this a Null? If NULL change the `amount` >0 to `amount` IS NOT NULL Let me know if you have any questions, ValiantSpur **Please mark…

The only way to reference a calculated field would be to either use the entire original Beast Mode in the next calculated field (referenced variables are not currently supported). The other option would be to build the first calculated column into the ETL process and have it calculted beforehand and then reference the new…

Something like this: CASE WHEN `servicefailure1` IN ('CCN','IF','CN','AF') OR `servicefailure2` IN (...........................) OR `servicefailure3` IN (...........................) THEN 1 ELSE 0 END

So you could write an inclusion Beast Mode that would go something like this: CASE WHEN Condition 1 is met OR Condition 2 is met OR Condition 3 is met THEN 1 ELSE 0 END Then filter on = 1. This way as soon as any one of your conditions is met, the row is included. Hope that helps, ValiantSpur **Please mark "Accept as…

This should be possible soon. I'm currently in a beta for custom roles right now that allows us to do that very thing. I would think you should see something in the next month or so. Hope that helps, ValiantSpur

We've done something similar, but actually use R to create the analysis and use a heatmap card to display the results after we push the numbers back into Domo. Hoping that the upcoming R ETL functionality will allow us to streamline this. Here's a guide to something like what we did in R:…

I may be wrong, but I'm pretty sure this functions as an AND clause. So you're asking if any rows contain ABC AND DEF. Are there records with those in the dataset?

You can do this from within the card options. You'll actually use the 'Move/Copy' feature and then select the new page you want to add the card to. The cards remain linked so if you make changes to one, it affects both. Use the Save As option to create an 'unlinked' version of the card. Hope that helps, ValiantSpur…