Best Of
Re: Determine user landing page by group membership
You have to use the Group ID and you can find it in either the Domo Governance Dataset "Groups" which can be found in the appstore by searching "Domo Governance Datasets Connector" or by going to the group in Domo and copying the ID from the URL:
Re: Determine user landing page by group membership
Yep! You can do this using the Group Management tool in Governance Toolkit. It is free. If you don't see it reach out to your CSM.
Go to More > Admin > Toolkit > Group Management > New Job > Manage Landing Pages
If you get stuck creating the job let me know!
Re: Pfilters
This is just a guess, but it could be possible that some of your Lane values contains characters that are causing this to break, for which you should URL Encode it, just to be sure nothing is breaking it. Sadly, MySQL does not offer a URLENCODE function AFAIK, so you'll need to do with a bunch of replacements, these are some of the most common ones:
%20 - space %27 - single quote %7C - | %26 - & %5E - ^ %2B - + %2D - - %25 - %
%22 - "
having this in your text might cause it to break, so I'd suggest replacing them, first you should replace the % sign and then all of the others, so you'll use something like:
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`Lane`,'%','%25'),' ','%20'),'''','%27'),'|','%7C'),'&','%26'),'^','%5E'),'+','%2B'),'-','%2D'),'"','%22')
There are many more characters that might need to be escaped, but these are the most common ones, so if it stills breaks, try looking at the lanes that are causing this to break and then identify what character is the one where it is breaking.
Re: Average Date Calculation
@damen I think that the average date will give you an incomplete or inaccurate result for this application. I suggest you compute each security's Macauly and Modified duration . This is the traditional metric for determining the "Average date" / interest rate sensitivity of a bond portfolio.
nmizzell
Re: Using date values for both x-axis and y-axis in chart
First, I think this would be a great enhancement request. It doesn't look like it's currently possible to use a date value in both axes. That said, I have a potential, moderately tested workaround for you.
What I would do is create a new column that is a copy of one of the axes then convert it to a string. you could then use this to display the values and the original to sort and filter on.
Jaketh13
5 Job Openings for Domo Users: January 8-14
Hello Domo community!
If you're looking for a job that uses Domo, look no further. We found five job postings that mention a need for well-versed Domo users.
O'Reilly Auto Parts - Store Operations Analyst
The Store Operations Data Analyst works with field and corporate leadership to organize and present key business insights using data analysis and visualization tools. The goal of a Store Operations Data Analyst is to understand specific business problems or performance opportunities and deliver meaningful insights from all available data to help our field leadership teams and other key stakeholders make important operational decisions.
- Experience required: 2 year or 4 year degree, preferably in Business, CIS, Computer Science, Economics or Mathematics.
- Domo or other Bi Tools experience
FloSports - Forecasting Analyst
The Subscription Forecasting & Insights team plays a critical role in predicting and monitoring subscriber demand. This role will support the team by creating predictive models, sourcing critical data inputs for models, and preparing subscription strategy presentations.
- Experience required: Bachelor’s degree in analytical field (Business, Economics, Finance, Mathematics, or Data Science) or equivalent experience
- Familiarity with cloud based analytics and CRM platforms (e.g. Domo, Salesforce) and data visualization tools.
O'Reilly Auto Parts - Inventory Systems Analyst
Create reports and alerts as necessary to enhance the performance of Inventory Control, Store Design, and Purchasing. Analyze areas above to see if additional reports/alerts need to be utilized to make each area more efficient. Perform specialized analysis to support maximizing sales and improving inventory efficiencies.
- Experience required: High school diploma or equivalent.
- Work with Information Systems to automate reporting and leverage software tools (i.e. Microstrategy, Dossier, Teamnet applications, Macros, Domo, etc) to reduce repetition in issuing reports.
Unilever - Marketing Technology Analyst
The role resides within the NA UniOps organization and requires an understanding of how marketing technology & data can accelerate business growth and be a differentiator. Areas of focus cover technology, data, and commerce.
- Salary: $83,200 to $124,700
- Experience required: 3+ years of experience in digital marketing analytics, personalization, and digital operations (ex. Business Analyst or Data Analyst role) Knowledge of analytics tools (Google or Adobe or other)
- Experience with visualization tools a plus (DOMO, Power BI, Tableau)
Trove Brands - FP&A Analyst
As a part of the Trove Brands Finance team, you will collaborate across the organization to help analyze results and play an integral role in driving profitable growth. This new role requires working with all levels within the company to deliver timely and accurate reporting and analysis of various financial metrics.
- Experience required: 1-3 years of applicable experience (CPG industry preferred)
- Familiarity with standard data reporting tools (SQL Server, Oracle, Domo, Tableau).
If you found this helpful, LIKE AND SHARE THIS POST. Additionally, please tag anyone in the comments below who could find this digest useful.
Re: December 2023 Community Forum Highlights
I'm so honored!! @GrantStowell I keep my thin figure by only eating and breathing Domo.
December 2023 Community Forum Highlights
The holidays have come and gone, and a new year has begun! Before we move on to 2024, let’s look back at last month’s Domo Community achievements.
Leaderboard’s Top 3
We have some very familiar faces on our leaderboard. While many of us were taking a well-deserved break over the holidays, some of you still had questions that needed answering. These three, along with a handful of other users, were here to answer the call. Thank you to everyone who put in the time and effort this month to keep the answers coming.
- @GrantSmith: 680 points
- @MarkSnodgrass: 528 points
- @ColemenWilson: 264 points
Top 3 Posts
Of the many discussions happening each day, these discussions stood out as some of the best. Follow the links and show these community members some love by leaving them a reaction.
- Trying to create a beast mode calc
- How to indicate the time of last dataset update in card title
- Radio button Filter
Huge shoutout to the following community members for asking great questions and finding even better answers: @Abe, @MarkSnodgrass, @DashboardDude, @DomoAmateur, @GrantSmith, @travorhouse, @ColinHaze, @MichelleH
Top 3 Ideas
The Domo product is always improving because of your ideas. Below are the ones that got the most votes. Click the links below and give these ideas additional upvotes to increase their chances of getting implemented into Domo.
- Enhancements to "Add existing Card" search box on Dashboards
- Drill Down to an Existing Card
- Consumption features
Congrats to these users for coming up with innovative ideas: @j1ammann, @AndrewMeierOptiv, @Nihar_Namjoshi_ex_Domo
Newest Contributors
Climbing the ranks is never easy, but this newest contributor certainly made it appear so. Congratulations to our newest Contributor @Kunal—we’ve got our eyes on you.
Community Member of the Month
Our CMM for December is an individual who eats, breaths, and sleeps Domo. We’re fairly certain he could build a fully functional dashboard with his eyes closed. John Le, or better known as the head dude of Dashboard Dudes, really showed up last month for the community. He participated in 16 discussions and had 13 accepted answers and 217 total points. Thank you, John, for your continued support of the community and Domo as a whole.
