BlueRooster Domo Employee

You almost had it. See small addition of ELSE statement below: CASE WHEN `Lead Source Detail` like '%Salesforce%' then 'Salesforce' ELSE `Lead Source Detail` End Hope that helps, Valiant **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

In order to do this you'll need to apply a 'Rank' column to your dataset (it can't be done at the card level). Once you have that 'Rank' column you can use that as a filter. Here's the info on creating a Rank or Row Count: http://knowledge.domo.com?cid=rank Best of luck, Valiant

You should be able to use something like this: MONTHNAME(`datecolumn`) Example: MONTHNAME('2018-05-20') would return 'May' as the result. https://www.w3resource.com/mysql/date-and-time-functions/mysql-monthname-function.php Hope that helps, Valiant

Right now the only real method for this is adding a drill path for your card. Any external linking from one card to another is limited to Page Analyzer Links (only applicable when going from table card to a different page altogether). More info on drill paths. https://knowledge.domo.com/?cid=addingdrillpath Hope that…

It might not work in your use case, but I've ended up just creating a new dataset with the final result value for this card type. Depending on how I want to round I either use the Round(), Floor() or Ceiling() function. Ex: I want 0.072234 (7.2234%) to get rounded up to 7.3%. CEILING(0.072234 * 1000) / 1000 Hope that…

When we have something like this with an 'Or' situation on permissioning we end up scripting it so that multiple policies get created for the same person or group. So the update script might look like this for you: target_ds policy_name delete_options policy_column user_group value (datasetid) Group_col1 update column4…

There's a few other posts where others have confirmed that the card description won't support HTML (which would be needed for links). https://dojo.domo.com/t5/Card-Building/Hyperlink-in-description/m-p/16065?search-action-id=18527702881&search-result-uid=16065…

Thanks Matt, We're looking at starting up editor training for a few groups here, may be able to have the users play around with this instead of production data. I would also be interested if anyone has ideas around training editor level users in using Domo. Getting some analysts out of their Excel mindsets can be a…

Take a look at the included post. There's a few things that could be affecting your Total Row calculation and these do a good job of covering your options. https://dojo.domo.com/t5/Card-Building/Table-Card-Total-Rows-Incorrect/td-p/36669 Best of luck, Valiant

We've done this before using table cards and building in links. Take a look at this link: https://knowledge.domo.com/?cid=samplebeastmode And then go down to the section on 'Page Analyzer Links'. You can modify this to just be an href to a specific page if you don't want all the extra parts that apply filters. Hope that…

So the way I would approach this would be to find the total # of gifts for each order ID and then add that as it's own column to your data. (The reason for this is that you can't use aggregation functions in beast mode filters) So to do this I would write a simple MySQL query like this (If you prefer to use the ETL tool…

A believe a Beast Mode function like this should work: FLOOR(`value` / 1000) * 1000 That will revert 17692 to 17.692. Floor function rounds decimals down to nearest integer and then multiply back by 1000 to get 17,000. Hope that helps, Valiant

So I found the European Central Bank has a link with conversion rates on it: http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml And info on it: https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html So here's how you can put it to use (the data updates daily btw). Go…

I'm not sure what your result goal is, but this will fix the syntax error. Gave you one of each method as an example: SUM(DISTINCT CASE WHEN `Travel Location` like 'Domestic' and `Travel Location` like 'International' THEN `Entered Hours` END) SUM(DISTINCT CASE WHEN `Travel Location` IN ('Domestic','International') THEN…

I built an app today and I'm getting the same issue (Upload button doesn't do anything). I've got a ticket open with Support now. If I find a resolution I'll be sure to post it back here. Sincerely, Valiant

Another option is to go into a SQL dataflow and calculate this grade you're wanting ahead of time. You could something like this: SELECT *, CASE WHEN (5 * FLOOR(DATEDIFF(`actual_ship_date`, `release_date`)/ 7) ) + SUBSTRING('0123455501234445012333450122234501101234000123450', 7 * WEEKDAY(`release_date`) +…

You can try the following (using something like the IF value under Category:Logical) https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_4/Creating_Columns_in_Workbench_4_Using_Calculations

It can be done in Workbench or within a MySQL transform. The easiest method is probably just to create a beastmode and then check to the box to 'Save to dataset' so you can reuse it as needed.

Either would work. Use it in a SELECT statement to take care of it at the data level, or just the CASE statement itself as a beastmode.

You could do a select from your data and use the following Case statement to replace all values > 10 with NULL. SELECT CASE WHEN `numbercolumn` > 0 AND `numbercolumn` <= 10 THEN `numbercolumn` END AS 'Cleaned Number' FROM dataset When using a case statement, anything that is not specified to be captured by a the WHEN…

Normally I will use 2 sorts to achieve this. If your X axis is your date range, first add your date value to your sort (to keep that from getting messed up). Then add a 2nd sort for your Series value. That will allow you to set it Ascending or Descending alphabetical order. Hope that helps, Valiant

Change your double quotes to single quotes around 'true'.

Unfortunately there's not a straight forward option for that in the Grouped Bar chart type. There are a couple of workarounds though. For your series you could create a Beast Mode calculation that returned say only 3 values and grouped the remaining values into an 'Other' bucket like this: CASE WHEN `Series` LIKE '1' THEN…

Interaction Filters are still part of the Beta program. I'm not sure when they will be officially released. Sincerely, Valiant

Here's a sample on the initial connection using Quandl var res = httprequest.get('https://www.quandl.com/api/v3/datasets/USTREASURY/YIELD?api_key=' + metadata.account.apikey) DOMO.log('res: ' + res); if(res.indexOf('Treasury') > 0){ auth.authenticationSuccess(); } else{ auth.authenticationFailed('Error connecting to…

Give this a shot: CASE WHEN `Warehouse` LIKE '%CA%' OR `Warehouse` LIKE '%WA%' THEN `Port to Warehouse Days` - 5 WHEN `Warehouse` LIKE '%GA%' THEN `Port to Warehouse Days` - 7 END You don't need the SUM in the THEN portion of your statement. Let me know if you have any questions, Valiant **Please mark "Accept as Solution"…

We had the same concern and reached out to our account manager and they were able to help us hide it for our users. Sincerely, Valiant

On your Orders card, you can go to the wrench in the top right and select Edit Drill Path. Then click 'Add a View' This will allow you to build out the 2nd level your card. For you instance, you would build out what you want the Order Items card to look like. Now when you go back to the top level card and then click on an…

Beast Mode calculations are done using MySQL. Here's a link that provides a lot of reference material when using Beast Modes. https://knowledge.domo.com/?cid=beastmode Let me know if you have any other questions, Valiant **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the…

All of the Facebook connectors in our environment require a user login (Facebook account). And authentication happens through this account. Which Facebook connector are you trying to use that is asking for client_ID and secret? Sincerely, Valiant