GrantSmith Coach

You can filter your card to display only the latest information using analyzer and then on you can edit the dashboard it's on and change the interactions and tell it to not be affected by any filters.

Segments only creates a subset of your data but doesn't remove it from the original dataset. If you need to you can create two beast modes to do the Canada filtering for each of your metrics -- Canada CASE WHEN `Country` = 'Canada' THEN `Value` END -- All Others CASE WHEN `Country` <> 'Canada' THEN `Value` END

You'll need to log a support ticket and have Domo's connector team update the API endpoint it's calling.

@Sudershan - Glad you got it figured out. Make sure to mark your answer as a solution so others will be more easily find it if they have a similar issue.

@MattBeal If you're not pre-filtering or dropping columns from your dataset with your views then you're likely not to see any improvement as the same amount of data needs to be transferred over to the ETL processing platform.

Data Fusion (or Blend as it's sometimes referenced) is the preceding version of DataSet Views. My understanding is they have the same functionality underneath but views offers more functionality.

In an effort to more simplify the comma delimited version of the beast mode I'm posting an alternative version instead of having to check every single different potential lengths it will automatically calculate the different sections automatically making the beast mode more readable. This version also handles numbers up to…

Hi @jmmc When I'm doing ETL optimization I typically like to think about being a teapot - Short and Stout. Short - Filter / Drop unused columns / reduce the amount of data as early as possible. Another option may be to create a DataSet view of your datasets if you're filtering the data / dropping columns first, this will…

Use Year To Date as the option instead. Alternatively you can reformat your data and use a custom date dimension offset to better handle period over period analysis. I’ve done a write up on this here: https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

@justin-millheim do you have any insight into this?

.

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?