BlueRooster Domo Employee

Lauren, You can use the RAND MySQL function if you use a SQL transform. The basic version of your sampling query would look like this: SELECT * FROM dataset ORDER BY RAND() LIMIT 10 Just increase the LIMIT to whatever size of sample you want and rerun the data transform each time you want new data. Hopefully that's what…

The only other option that I'm aware of would be to build this in a SQL transform. You can't do this via BeastMode as having aggregation functions (which would be needed to rank your items) are not supported in the Filters section. Via SQL it would look something like this : SELECT `Identifier`, SUM(`Value1`),…

For a similar calculation, I ended up adding a new row to my dataset and had it calculate the MAX applicable date for the range. That way you can use the "MAX Date" almost as it's own variable in your beastMode. So if you added a `MaxDate` column to your data your new BeastMode would look like this: sum(case when…

This might not be exactly what you're looking for, but I'm not sure how else to accomplish the functionality you're looking for. Ideally you would have an option for "This Fiscal Year" in the date options, but you could build a BeastMode filter to simulate that function: CASE WHEN YEAR(CURRENT_DATE()) = (`fiscal`) + 1 THEN…

@John-Peddle You're very welcome. Glad I could help!

Ken, Setting the initial date range to This Year and allowing it to be visible to the user let's the user change the range beyond the first year if they wish. We have several cards where we use This Year as the default and if the user wants to say look at the Previous Year instead, they just use the date range drop down to…

I haven't tested this specifically with a Box dataset. However, we do this quite often with ODBC datasources in our environment. It has yet to cause any issues on our end with cards/dataflows. If we need the newly added columns, it's a matter of opening the dataflows and adding those columns where needed. Hope that helps,…

So one thing you could do would be to edit the card and create a BeastMode to use for filtering. You could do something like this: CASE WHEN `Tags` LIKE '%help_request%' AND `Tags` NOT LIKE '%Closed_by_merge%' THEN 'Show' ELSE 'Not Show' END You could then drop that BeastMode into your Filters section and either use it as…

To set the default to This Year, instead of All Time, edit the card in the analyzer. Make sure the DATE option is enabled, and then under the Date Range, click the drop-down and select Current -> This Year. Also make sure the "Hide Date on Card Details" is unchecked: Now if you save the card, the default will be set to…

I'm unsure of an ODBC method of connection, however there is the Domo R Plugin which allows you transfer to and from Domo to R. https://knowledge.domo.com/Prepare/Magic_Transforms/DomoR_Plugin Hope this helps, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the…

Hi Jennifer, Can you tell me if "help_request" and "closed_by_Merge" are in the same column of data? Or are these two separate columns? I might be able to point you in the right direction once I know that. In the mean time, here's a link that has some quick videos showing how to filter data:…

If I understand what you're wanting, you'll need to break each "yes check" into separate case when's like this: SUM(CASE WHEN `Inventory` like 'Yes' THEN 1 ELSE 0 END + CASE WHEN `Malware` like 'Yes' THEN 1 ELSE 0 END + CASE WHEN `App Software` like 'Yes' THEN 1 ELSE 0 END + CASE WHEN `Logging` like 'Yes' THEN 1 ELSE 0 END…

Under the data label settings, you could enter something like this: %_VALUE<br>%_PERCENT_OF_CATEGORY Here's a screenshot of the various options (the <br> is the line break for the text) Let me know if you have any issues. Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say…

Using your sample data this seemed to work on my end: CASE WHEN `Make_It_Personal` *0 != `Make_It_Personal` THEN `Make_It_Personal` * 1 ELSE 0 END Let me know if that wasn't what you were looking for. Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the…

Hopefully someone else can chime in on the ETL portion. But you can create the filter by creating another BeastMode CASE WHEN CASE WHEN SUM(`Order Quantity`) > SUM(`Quantity Available`) THEN SUM(`Value Available`) ELSE SUM(`Order Value at 02 Slow Item Cost`) END > 5000 THEN '> 5k' ELSE '< 5k' END That would let you filter…

How are you wanting your card filter to behave? It's possible you may not need to do an ETL.

In the Admin section, click on the Cards tab Under the Owner column, click the filter icon in the top right and search for the owner you want to replace: Next, hit the SELECT ALL button in the top left to select all of that owner's cards: Lastly, hit the Edit drop down in the top right and choose "Change Card Owner" Select…

Currently I don't know of another way. There is an idea that has been "Assigned Pending Review" to add the ability to use R within ETL transforms: https://dojo.domo.com/t5/Ideas-Exchange/Dataflow-Ability-to-write-R-or-Python-code-within-a-ETL-Dataflow/idc-p/25719#M5025 Might be worth upvoting to throw some more support…

Hey Ben, So assuming you have your data imported from Excel. When you're in the analyzer building your new card, hit the "Add Calculated Field" button in the bottom left to create a BeastMode. Here's the way you would code this (Domo uses MySQL): COUNT(CASE WHEN `Stage` LIKE 'Closed Won' THEN 1 END) / COUNT(`Stage`) * 100…

The way we went about solving that here was to first create a table of "Business days of months" for large timeframe (ie, 2010-2200), as long as you have a way to reference what business day each day actually was/will be. I then created an ETL using multiple left joins to my data using that date range to create "working…

Here's a beastmode to calculate the difference in months period_diff(date_format(`Enddate`, '%Y%m'),date_format(`Startdate`, '%Y%m')) Just plug in your own date values and you should be good to go. Let me know if that wasn't what you were looking for. Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post…

John, We have a couple of Nested bars with driling paths. The option to sort on totals has to be set for the main card and each drill down. Here's a screenshot of the option (Under General): Give this a shot and let me know if that was or wasn't what you were looking for. Sincerely, ValiantSpur **Please mark "Accept as…

I posted this link on your other question, but it may help with both situations. Let me know if you have any issues. https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench/Workbench_4/05Understanding_the_Workbench_4_User_Interface#Schema

Check out the Schema section here. Is this what you were looking for? https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench/Workbench_4/05Understanding_the_Workbench_4_User_Interface#Schema Looks like this may answer both of your questions. SIncerely, ValiantSpur

You could try this: Step 1: Apply a "Percentile" column against your time to close date range. If you use a data transform to create a column that calculates your time to close, you could then use the follwoing sample code to build a 'Percentile' column for the values you find. SELECT a.*, ROUND(100.0 * (SELECT COUNT(*)…

The only way I'm aware of to stack metrics like that would be to create a custom app. The design studio route is probably the easier of the two: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/Custom_Apps/Adding_a_Custom_App_to_Domo Hope this helps, ValiantSpur

You'll most likely have access to the data from Saleforce to build your card. You can take a look at the details on the Saleforce connector available in Domo here: https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Salesforce_Connector Sincerely, ValiantSpur

@IVG glad to hear it! @jhl no worries, Iol. I mainly stick to SQL so I'm always having to look back and see what's in the ETL section.

You can also do this via ETL if it's easier. Here's what it would look like (i included the detail for one of the groupings: Just make sure to group by your date field and average your value field. Hope this helps, ValiantSpur

Once you have each of the calculations set as BeastModes. You can drag them to the Filters section. See below for screenshot: When you drag it up to the filter section, set each value to "Is 1" Here's a link to the long explanation of…