GrantSmith Coach

.

You can use a table card and sort on the number of responses ands then in the analyzer settings under filter you can set the number of rows to return to 3. Doing a drill path to get all of the reasons will be difficult as Domo automatically filters your drill card based on what was selected

Some minor tweaks to your beast mode: CASE WHEN YEAR(`Booking Year Nbr`)= YEAR(CURDATE()) THEN "CY" ELSE "PY" END

The Java CLI has a swap-owner command with the -r flag to swap the owner of a report. Does require admin privileges to perform the swap.

This is something done with your IdP / Identity Provider using Single Sign on. You can read more on it here: https://domohelp.domo.com/hc/en-us/articles/360043428233-Domo-Mobile-Security

A calendar dataset is one that lists all of the dates as sort of a dimension table. The sum is the count of dates you're getting from the group by when grouping on your ID field. You just need to join your dataset with the group by tile output based on the ID field to tie the sum of days / count back to your original…

@MichelleH - Good catch, thanks!

@NathanDorsch It's the correct syntax. Sometimes the syntax highlighting has a few issues highlighting everything correctly depending on the keywords.

Currently no, only the user can modify their own notification settings. That'd likely be a good idea to submit to the idea exchange to give admins more control of notifications.

CASE WHEN COALESCE(TRIM(`field`), '') = '' THEN 'Blank' ELSE 'Not Blank' END COALESCE will return the first non-null value it finds, used in this case it's saying if the field is null return an empty string. I've wrapped the field in a trim to remove any leading or trailing whitespaces in case someone has a value of all…

You can use a beast mode with CONCAT to join multiple column values together. CONCAT(SUM(`delivers`), ' delivers ', SUM(`delivers`)/SUM(`total`), '% delivery rate')

Hi @meekey you’ll want to use a lag function to get the last three values. Typically I use this when doing a rolling average like you’re needing. I’ve done a write up on rolling average and lag functions here: https://dojo.domo.com/main/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages window functions…

Whatever username and Password you use the data you’re able to pull it will be restricted based on that username and password. So yes you will likely need an admin level account to get all of the data out of day force

You’d need to incorporate a calendar dimension table in an ETL. However because magic ETL doesn’t support conditional joins it gets a little messy. You would need to add a constant to both a Calendar data set and your actual data set and Collett join column and set it to a value of one. Then you would join your calendar…

Currently there isn’t a way to have Domo do a segment in this way easily. One hack would be to duplicate your dataset and have an extra column to “filter” on which just has the value you want to highlight however this can drastically increase the size of your dataset as you’d need to replicate it as many times as possible…

Did you copy the dataset as well or just the cards? Are you doing any filtering on the new card? Are you using all of the same settings on the cards as their original?

Because you’re using a federated dataset it will only update the information when you query it like in your case with the view. what happens if you recreate the federated dataset? Does the row count then match?

Are you clicking done in your notebook card after being in edit mode before you navigate away?

Have you updated to the latest version of workbench and rebooted the server or in the famous words of the IT Crowd: “Have you tried turning it off and on again?”

When looking at the history of the execution does it show writing the data as successful (you'll need to click on the success green oval on the execution to get the detailed step breakdown)? In the preview pane on the output tile does it show data?

Have you used an SQL transform to add indexes to your two tables on id, id2 and date fields? Alternatively have you used the new MagicETL as that will be much faster.

Currently no, it's all or nothing when it comes to editing cards. You can't select specific cards a user is able to edit. I'd recommend adding this as an idea to the idea exchange because I'm sure others are needing this specific functionality.

Hi @NateBI You'll want to use a Magic ETL and Unpivot your data such that you have a column for the different types of clean and then use that column in your Pie Chart. The pie chart only supports a single value for the pie name.

they only thing out of the box that would handle this correctly is doing a year to date selection. What I recommend is to configure your own date offset dataset to do a more apples to apples comparison. I’ve written up on this method before…

It doesn't appear to be currently possible within the smart text on a title however you can utilize a notebook card and add a summary number to display the minimum or maximum values in your dataset. https://domohelp.domo.com/hc/en-us/articles/360043430233-Adding-a-Notebook-Card#4. I'd also recommend adding this as an idea…

Yes as the data is filtered to that specific range and you no longer have access to the prior period data. I recommend utilizing a custom period calendar date to allow you to still have the PoP values even if the data has been filtered to a specific time frame. I've written up on this before here: A more flexible way to do…

You can do some simple date manipulation to get the Monday of the current week with a Formula Tile `Date` - INTERVAL (CASE WHEN DAYOFWEEK(`Date`) = 1 THEN 6 ELSE (DAYOFWEEK(`Date`) - 2) END) DAY DAYOFWEEK returns a number between 1 (Sunday) and 7 (Saturday). The CASE statement is checking if it's a Sunday to subtract 6…

SUM only takes a single argument. You'll need to add them together. Note that I'm adding 3 sums together as it will handle nulls otherwise if I add CURRENT_INVENTORY + NONCURRENT_INVENTORY + OLD_INVENTORY and if any one of those values is null then the entire value will be null causing incorrect summations. SUM(CASE WHEN…

You need to put your condition inside your aggregation. SUM(CASE WHEN `Order Src` LIKE 'CSR' THEN `order_line_total_price`) END) Also - as a side note your LIKE 'CSR' isn't matching on any wild cards so it's expecting Order Src to be equal to exactly CSR. if you're wanting to see if CSR is anywhere inside the Order Src…

Are you using Magic ETL or MySQL ETL? Can you post a screenshot of. the tile / logic that's being used?