ColemenWilson Coach

You could create a new field in the "bad" dataset to split the Division field on the comma delimiter, then clean up the leading characters, then append the data so you can then apply PDP policies as you do on the "good" datasets. So your data would go from looking like this: To this: Would that work for you?

You can notify Domo by opening a support case with them. Alternatively, you can use the Atom RSS Connector to get a RSS feed for any news site you want. Copy the URL of the page you want the RSS feed for. Go to https://rss.app/ Sign up for free Select "Webpage to RSS Feed" 5. Paste the URL and generate the RSS feed. 6.…

I hope someone has found a better way, but here is what we have done: 1. Do not give them the grant to manage datasets 2. Create a dataset tag "RESTRICTED" 3. Add the RESTRICTED tag to restricted datasets we don't want them to see. 4. Bulk share all datasets without the tag "RESTRICTED" to them as "Co-owner" -You can share…

Hi @user04612 , I would recommend line or bar charts for the 3 charts. This is what we use for our weekly active users: The orange line is the linear regression to see the trend. To build this: 1. Use ActivityDate as your X axis 2. Create the following Calculated Field (Beast mode): COUNT(DISTINCT `UserID` ) 3. Use your…

SUBSTRING_INDEX(ID, '_', -1)

Yes this can be done using DomoGPT in a Jupyter Workspace. If you come to Domopalooza, you can hear @nathankilcrease explain how this is done. He may even be willing to help out sooner than that if you ask him very nicely and offer him some legos.

@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