ColemenWilson Coach

@NateBI that was true historically, but with GA4 that ability has been lost. At least the last time I spoke with @Ashleigh that was the case. If you are on consumption you can add instances for some amount of credits per month, reach out to your CSM/AE for details. We like having the separate instance for education so that…

Have you taken the Domo certifications? The trainings for them are free and there are lots of best practices shared there. The MajorDomo certiciation training path is where I'd start as it has the most best practices around governing an instance and growing. For prioritizing tasks and keeping things organized, I strongly…

Yes. You can remove them from the direct sign on list if you are using SSO. If you are not, setup SSO. You can also delete the user or change their email for their account.

Ahhhhh that's way easier! Just add the quick filter, make a selection in analyzer view to the quick filter and then save! Forcing a selection on the filter will force a selection on the bar chart. It changes the user experience only slightly. If you are opposed to that you could use a separate dataset for the bar chart…

@GrantSmith taught me how to do this here: Let me know if you get stuck!

Hey Nate! Google Analytics is currently the only way to track progress. Tracking who each individual is isn't currently possible. @Ashleigh correct me if I am wrong? Our team has switched to building trainings using other LMS tools and them embedding into Domo. If you are on consumption you could also add another instance…

CONCAT(`First Name`,'<br>',`Middle Name`,'<br>',`Last Name`)

This happens automatically when you drill down. You can apply additional filters to the drill path in the drill path editor. Here is a KB article that walks through the steps of adding a drill path: https://domo-support.domo.com/s/article/360042924094#add_a_drill_path_to_a_chart

This happens automatically when you drill down. You can apply additional filters to the drill path in the drill path editor. Here is a KB article that walks through the steps of adding a drill path:

USA Beast Mode: (CASE WHEN `Country` = 'USA' AND Fruit = 'Oranges' THEN `Picked` ELSE 0 END + CASE WHEN `Country` = 'USA' AND Fruit = 'Apples' THEN `Picked` ELSE 0 END) / CASE WHEN `Country` = 'USA' AND Fruit = 'Pineapples' THEN `Picked` ELSE 0 END Mexico Beast Mode: (CASE WHEN `Country` = 'Mexico' AND Fruit = 'Oranges'…

Hi @vsrinivas I would recommend using a dataset alert. Here is a KB article walking through dataset alerts and how to set one up: Alternatively you could use a card alert. You'd need to build a card that counts the number of rows and partition by some update ID or date like _BATCH_LAST_RUN_ or _BATCH_ID_

I think it is because you have both Incident Date and Year-Month in your ORDER BY. Also, do the fields in the beast mode match fields in your data? SSI Monthly, Incident Date, and Year-Month?

There is a an idea for this in the ideas exchange that you could upvote: https://community-forums.domo.com/main/discussion/52771/google-slide-integration People have some ideas in the thread on workarounds for now. Also I see this 3rd party Slideform that can integrate the two:

You can order it using filter cards on a dashboard but not in the quick filter on a card.

Agreed. I have cliked the "x" a dozen times and it just keeps coming back. It's time for it to be dismissed permanently. I'm tired of seeing this stock model, and now I am seeing her outside of Domo as well. I can't escape. She is everywhere.

It will still work, it just doesn't show up in the functions list - along with many other mysql functions.

This is using a beastmode. I built it assuming month level granularity.

Gotcha! If you'd like, you could submit this as an idea in the

In your table it shows "Evaluation". Aren't you looking to see who did the evaluation prior to the upgraded procedure? If so just filter out anything that isn't "Evaluation" or "Upgraded Procedure" then do the lag function and you'll get who did the evaluation prior to each upgraded procedure. Be sure to partition on…

Yeah but then it will become a string instead of a number. Any reason you would want to do this? CONCAT('$',`YourValue`)

CONCAT(UPPER(LEFT(`YourField`,1)), SUBSTRING(`YourField`, 2))

@user04612 Your Account Executive would know who your CSM is and/or could help as well. If you are on User License model then you could purchase Integration Studio which gives you all writebacks. If you just need one writeback I believe that is an option as well. If you are on consumption you will still need to request it…

You can use the following for SSI Rolling: ( SUM(SSI Monthly) + LAG(SUM(SSI Monthly), 11) OVER (ORDER BY Year-Month) + LAG(SUM(SSI Monthly), 10) OVER (ORDER BY Year-Month) + LAG(SUM(SSI Monthly), 9) OVER (ORDER BY Year-Month) + LAG(SUM(SSI Monthly), 8) OVER (ORDER BY Year-Month) + LAG(SUM(SSI Monthly), 7) OVER (ORDER BY…

@Data_Devon I'm here to chime in! Hide grid lines and then add quadrant lines = 0

Fixed functions only work in beast modes. To do this in ETL you will need to add a constant if one doesn't already exist, this will be needed for a Group By to sum up Amount. This step replicates the first part of the fixed function by getting you a total amount for sales for your grouping. The next step is to join the…

I am assuming you also have dates? Do you have a date time? Some way to order the events taking place? If so you could use a lag function and look for the procedure that occurred prior to the Upgraded Procedure.

I've set something like this up. I append the data everytime it updates instead of replacing it. I then do a lag function to see what the previous value was and compare the two. If they don't match it triggers an alert.

Congratulations @Data_Devon! @everyone please upvote The Text Card idea!

We were able to meet a few weeks ago and get this figured out!

There is a Domo Dimensions Connector dataset called countries_latitude_longitude.csv but I'm not sure the best way to accurately join this data. You'd need to maybe round the data so it would join cleaner (maybe to the tenth?) but I worry about errors. The better option would be to use DomoGPT in a Jupyter Workspace model…