Best Of
How to use a user selected date parameter in a calculated field?
Hi,
I would like to include a dynamic user selected date parameter in a calculated field. Where the user selects a Start (selected_start_date) and End (selected_end_date) from a date filter then depending on what date ranges are chosen run the following sample calculation:
IF user_sign_up_date <= selected_end_date THEN 'Active'
ELSEIF user_sign_up_date >selected_end_date THEN 'Inactive'
ELSE NULL
END
I'd wish to do this in the Chart section in DOMO.
Re: removing/modifying columns in charts has become difficult
@Jbrorby yes this has been a hot topic in the domo community and a number of people have been reporting challenges with it. You can upvote @Ashleigh's post (https://dojo.domo.com/main/discussion/55833/silent-updates#latest) where she mentions it to let Domo know that we'd love to see them provide more information around these types of updates!
mhouston
Re: Providing Domo exercise for training to newbies
@NathanDorsch Have you checked out Course Builder? Its a way you can create your own courses and then publish them as cards and you can even track training for them. I created these and require my users to complete them for training. Here is an older video I made that shows how I used Course Builder to implement training in my instance https://www.youtube.com/watch?v=l4avUIsR34g&list=PLc_JazWEwlVrx2M5goKndI8SkBaHbmbO1&index=2.
You can download the training Domo has provided and edit/customize it in Course builder. I used Domo's training as a starting point and then added my own examples and branding before publishing the training to my instance.
For example data I use the Domo Governance and Domostats datasets. There is also a Sample data connector in the appstore.
Ashleigh
Re: Display Data based on User?
You’ll want to look into using PDP as you can define which rows are available to specific users without having the other data exposed to them.
https://domohelp.domo.com/hc/en-us/sections/360007334593-Personalized-Data-Permissions-PDP-
Re: Request for Topics
- How to optimize data pipelines in Domo (DSV, Magic 2.0, Upsert connectors, etc.)
- Dashboard design best practices (What makes a dashboard stand out? How do you tailor your dashboard to the intended audience?)
- More Domo Everywhere content!! This feels like a black box at times, as I haven't seen very many public-facing training videos on the topic.
Thanks Professor!! Love the new video!
ellibot
Re: Request for Topics
- +1 on Account Management. I have spent a ton of time creating dashboards to audit my instance (more advanced than just DomoStats). In order to monitor what is coming in, going out, and managing users (especially across multiple instances). Learning how/why to create custom roles would also be a good part of that.
- +1 on Domo Everywhere content. Best practices for creating published jobs would be good. Especially since each job creates a new federated dataset. I made a mess when I started and now I have to clean it up 🙃
- How to utilize new features once they come out, I always struggle creating content for my users regarding new features so then we just don't end up using them for a while. Having some concrete examples would be useful (ex. I never got to using Segments and I still couldn't tell you how to use them).
- Best practices for instance health. I have so many users creating so many flows and rows of data that could be much more optimized. Going over Magic ETL best practices for a clean instance and quicker run time would be useful.
- Creating alerts to manage data. This is one I learned to do myself by doing error checking in flows to create error datasets, making error checking cards, and more recently just putting alerts on a dataset. Knowing your data is wrong before it has time to make it to the end user is very useful.
Ashleigh
Re: Export Beast Mode from Beast Mode Manager
This is available through the Domo Governance datasets. If you haven't used this connector before, it has quite a bit of information about your instance. Go to your data center and then click on Connectors and search for Domo Governance. You can then choose Beast Modes as a report and it will add the dataset with the information you need.
Re: Release Notes - What Changed
@RobynLinden and I reached out to the Analyzer PM about this and he informed us an update should be coming soon.
Ashleigh
Re: How can I remove items from a mega table using a beast mode?
You'd likely need to utilize a window function and a case statement. Something like this might work for you
MAX(MAX(CASE WHEN `Country1` = `Concat Field` THEN 1 ELSE 0 END)) OVER (PARTITION BY `Part1`, `Country1`)
Then use this field in the filter to ignore values of 1.