BlueRooster Domo Employee

You'll need to create your count ahead of time in an ETL or Data Transform and then add the result back to your original dataset as a new column. This you can then use to filter. Card level filters don't allow you to use things like Count, Max, Min, Sum in their calcuations. Hope that helps, Valiant **Please mark "Accept…

If you don't already have them, you'll need to get the DomoMetrics datasets. To get these, simply email support@domo.com requesting DomoMetrics DataSets and they'll do it for you. Once you have these enabled, there's a dataset called Card Usage with Datasource and Owner Information that should give you what you need (just…

So... just spitballing here. But as users can setup their phone numbers on their Domo profile. I bet if you turned that on, and one of the numbers called you, it would then use Domo's name for the person on your phone as the ID. But that's purely a guess I'll be interested if you find out more, Valiant

I'm not aware of a way to accomplish this to continue in your drill path on your current card. However, you can setup the View More button to apply as a dynamic filter to a new page in Domo. So you can have either one or multiple cards on the new page that all get filtered by whatever the user clicked on. Here's a link to…

No, you'll need to do this with a SQL Data Transform. You're having to compare the dataset against itself so you can't use only card level beastmodes. Once you open the SQL transform, select your dataset and you should be able to then tweak my code to match column/dataset names. Let me know if you need further assistance,…

That was a fun one. Here's the query I used: SELECT a.* , CASE WHEN a.`Currency 2` = 'USD' THEN 1 ELSE (SELECT b.`Price` FROM `currency_data` AS b WHERE a.`Currency 2` = LEFT(b.`Pair`,3) AND RIGHT(b.`Pair`,3) = 'USD' AND b.`Time` <= a.`Time` ORDER BY b.`Time` DESC LIMIT 1) END AS 'Currency 2/USD' FROM `currency_data` AS a…

You're not able to do this at the card level and would need to calculate this at within your ETL/Data Transform process. Calculations at the card level are viewed "row-by-row" so if your calculation is comparing Amount in Row 1, a SUM(Amount) would only return the amount of Row 1 at Row 1 since it's not grouped and still…

You need to define the column a second time after your "and". (CASE when `score`<=.2 then '2 or less' when `score`>.2 and `score` <=.5 then '2 to 5' when `score` >.5 and `score` <=.7 then '5 to 7' when `score` >.7 and `score` <=.8 then '7 to 8' when `score` >.8 and `score` <=.9 then '8 to 9' when `score` >.9 and `score`…

So you could go down the page filter route. However I think the best solution would be to wait a bit. The new interaction filters should be coming soon and this brings full page interactivity into play. This would allow you to click on a month from one of your cards and have the rest update accordingly. As this is…

Made a couple small tweeks. Give this a shot: SUM(CASE WHEN YEAR(`Date`)=YEAR(CURDATE()) then `Online` else 0 End) / SUM(CASE WHEN YEAR(`Date`)=Year(ADDDATE(CURDATE(), interval -1 year)) then `Online` else 0 End)

If the categorization grouping is something that is going to be used in several places and not just one card, I would recommend doing this at the dataflow level. This way you have one place to make changes if necessary and you can also carry these groupings through to other datasets as you make them in the future.

The only way I've been able to troubleshoot this previously is to go to the offending dataflow, and on the History tab you can see Version #s of your dataflow. If you mouseover each one (on the right next to status) you can actually "Make Current Version" on a previous version, Run and capture a snapshot of the columns,…

Your url is invalid as it's looking for a valid {driver-id}. Once you know a valid ID you can enter that instead.

I'm in the same boat right now actually building out an API connector for some accounting software. What I thought would be a quick data pull has turned into several hundred lines of code and counting... Oh well, at least we're not alone in the struggle!

You'll probably also need to identify a specifc driver id from the looks of that script. I'm thinking you'll probably have to call the drivers api to get a list of driver_ids and store that in an array. You'll then need to loop through the array using your daily_logs url to build out results for multiple drivers and all of…

You'll need to put your endpoint in the call script like this: var res = httprequest.get('https://api.samsara.com/v1/fleet/drivers/{driver_id}/hos_daily_logs' + metadata.account.apikey) DOMO.log('res: ' + res);

From what I can tell you'll want to create a custom connector using the API Key authentication option So you'll want to start here: https://api.domo.com/builder/index.html Under auth use API Key, drop your key into the API Key field on the right and then you'll want to initiate a request. Here's an example I built for…

Currently there's no way to do this. There is however an open idea on the Idea's Exchange here: https://dojo.domo.com/t5/Ideas-Exchange/Hard-link-to-Beast-Mode-functions-within-other-Best-Mode/idi-p/22781 Be sure to give it an upvote. (I did!) Hope that helps, Valiant_Ronin **Please mark "Accept as Solution" if this post…

Can you tell us what filters are being applied when you're drilling down into your chart? Also where are you clicking to drill down? (If you click on an X-axis value like May 2018 it will only pass that as the filter. If you instead clicked on say Series Value 1 in the May 2018 bar, both filters should be passed) Here's an…

Do you have a column with the ticket age already calculated or are you doing that as a beastmode? You could create something like this: AVG(DATE_DIFF(`closedate`, `opendate`)) Put the AVG beastmode calculation as your first value in the 'Y Axis' area. Then create separate beast modes for each of the date ranges and add…

I was able to replicate that behavior as well. From what I can tell, the only way around it would be to use a line/bar chart, manually calculating your variance and build in a case statement for if your previous period is negative. If it is, this its the variance of the absolute value of the previous period compared to…

If you'll go into the Domo Data Connectors on your instance, search for DomoStats and Connect. There is a report called 'People' that returns all users in your instance. It also has the users associated 'CreateDate'. Hope this helps, Valiant_Ronin **Please mark "Accept as Solution" if this post solves your problem **Say…

If you've got your Month and Year already, you could do the following: 1. Add a constant where the value is 1 and the type is text 2. Add a Combine Columns and follow the screenshot below to combine the Month, 1, and Year into a string your example + mine would result in a string of 7/1/2018 3. Use Set Column Type with…

You could do something like this: AVG(DATEDIFF(CURRENT_DATE(), `Hire_Date`)) DateDiff using Current_Date and Hire Date will give you the # of days each employee has been employeed. Averaging that by office should give you what you're looking for. Hope that helps, Valiant_Ronin **Please mark "Accept as Solution" if this…

You'll want to use a CASE WHEN statement like this: CASE WHEN DATE_FORMAT(`birth_date`,'%m/%d') = DATE_FORMAT(CURRENT_DATE(), '%m/%d') THEN 'Yes' else 'No' END Give that a shot and let me know if you need anything else, Valiant_Ronin **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by…

You'll want to use a CASE WHEN statement like this: CASE WHEN DATE_FORMAT(`birth_date`,'%m/%d') = DATE_FORMAT(CURRENT_DATE(), '%m/%d') THEN 'Yes' else 'No' END Give that a shot and let me know if you need anything else, Valiant_Ronin

A couple of questions around your dataset. Do you have historical data of your deals or is it only current state? Also, can you speak to the stage order vs status of the deals. Can deals move back and forward or only forward? Is stage_order_nr = 5 only for 'won' deals? If your stages are sequential (only going 1,2,3,4,5)…

What you seem to be referring to is interactive page filters. Where clicking on a part of one card will cause other cards on the page to apply the same filter. This was a feature previewed at Domopalooza 2018, but has yet to make it to production. I'm hoping this is something we'll see soon as I have seen the new 'Slicer'…

Normally I'll set the text color to black under the General properties tab. And then I'll also disable drilling down to data table under drillpath edit. I'm not sure if you can remove the text hover property of showing underlined when moused over though. 

You'll want to use the tilda (`) anytime you're encapsulating a columnname present in your dataset. You'll use the single quote (') when you are enclosing a string. In your case, you're adding a string '%' to the end of your calculation. Hope that helps