Best Of
Re: Rename Filters? Persistent Filter Selections?
They would look like this. When you select an option in the card it will automatically add the filter bubble at the top.
Ashleigh
5 Job Openings for Domo Users: August 13-19
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.
Stripe Theory - Marketing Data Analyst
We are looking for a Marketing Data Analyst who has a passion for all things marketing, is a great writer, and can uncover — and simplify — actionable insights for clients and stakeholders.
- Experience required: 2-3 years of experience in a similar marketing strategist or marketing analytics role.
- Preferred: Experience in building tables, visualizations, and dashboards with a BI tool such as Tableau, Domo or similar.
Whereoware - Data Analyst
Main tasks will include designing, building, launching, and optimizing meaningful dashboards to support performance measurement objectives.
- Experience required: Minimum three years of recent experience working as a Data Analyst or related role
- Direct experience within data visualization tools such as DOMO, Tableau, Power BI and/or Looker building data connection, transform, and dashboard builds
Happinest Brands - Business Intelligence Lead
The BI Lead must be structured when it comes to data organization, always keeping in mind efficiency, scalability, and flexibility within the data.
- Experience required: Minimum of 5 Years Experience in Data Analytics and Business Intelligence Platform Management
- Experience using BI Applications such as Domo, Tableau, Looker (Domo Preferred)
V-Soft Consulting Group, Inc. - Senior BI Developer
SHORT JOB DESCRIPTION
- Experience required: 5+ years of direct experience in BI development and reporting.
- High-level proficiency in customizing and managing BI tool frontend environments (Domo is a big plus).
Dice - DATA ENGINEER
Bring depth of experience and influence chosen technologies and design implementation Database, Data Warehousing and Analytics.
- Experience required: 5+ years of relevant experience in data analytics or process improvement
- 5+ years of relevant experience in data analytics or process improvement
If you found this helpful, LIKE AND SHARE THIS POST. Additionally, please tag anyone in the comments below who could find this digest useful.
Hello Domo community
Hi everyone,
I'm the BI Analyst for Banff & Lake Louise Tourism in the beautiful mountains of western Canada. I come from a geomatics and spatial data background, and have been using Domo for almost 2 years now.
Re: Filter on two or more columns
Python configuration not needed. We build ours in Magic ETL utilizing the Formula Tile.
Steps:
- If you would like to create the URL for a page:
- Copy the pageID from the page's URL
- Paste it into the link below to replace pageID
- Copy the following text: [{"column":"columnToFilterOn","dataType":"string","operand":"IN","values":["valueFromColumnToFilterTo"]}]
- Replace columnToFilterOn with the EXACT column name from the datasource.
- Replace valueFromColumnToFilterTo with the EXACT value to use for filtering
- Go to this link: https://meyerweb.com/eric/tools/dencoder
- Paste the value from step 3 into the text box
- Click the "Encode" button
- Copy the encoded section of the URL, it should look something like this:
- %5B%7B%22column%22%3A%22DSO%20Account%20Name%22%2C%22dataType%22%3A%22string%22%2C%22operand%22%3A%22IN%22%2C%22values%22%3A%5B%22Practice%20Dental%22%5D%7D%5D%20
- Combine the first part of the URL from step 2 and the encoded section of the URL.
- The final result should look something like this:
- https://yourcompany.domo.com/page/338030843?pfilters=%5B%7B%22column%22%3A%22DSO%20Account%20Name%22%2C%22dataType%22%3A%22string%22%2C%22operand%22
- Copy the pageID from the page's URL
In ETL you can make these dynamically for a page. Use the replace text tile or formula tile to create the unique parts of the URL. Then in a formula tile use a CONCAT function to bring the needed pieces together.
More here:
Example #1 shows what the syntax would be for multiple columns.
Re: Help the Newbie! SQL Connection not working anymore
Personally, I would make a plan to migrate all of your datasets over to Workbench so that they all run through that. Your security should like that better actually.
As far as the SQL connector, if you have some that are running and some that aren't, if you have verified that they are all configured the same, then you might need to open up a support ticket and support will be to identify more detailed error messaging than what is being presented to you.
Re: Help the Newbie! SQL Connection not working anymore
You can install Workbench on a VM. That's where mine is installed. Just needs to be any Windows OS. A VM would be the best location because, as you said, if it is on your laptop, then it will only run when your laptop is on and connected to the internet.
Re: Help the Newbie! SQL Connection not working anymore
I would suggest using Workbench if you are able. It is very easy to use. With the SQL connectors, you are going to need to make sure the correct firewall ports are open, which can be challenging for some organizations.
In Workbench, you can create an ODBC connection and then use the connection for your connection string. Workbench will transfer the data securely for you and gives you flexibility over scheduling and data transformations. It's definitely worth looking into.
Re: What is the formula to convert Julian dates (format Cyyddd) to regular date - not datetime
DATE_FORMAT(`Julian`,'%Y-%m-%d')
I tested it with this data and it is working, test is the output of the above beastmode:
App Studio Alpha Opportunity
Hello Domo Community,
We're thrilled to share an exciting opportunity with you. As we approach the end of this month, we're gearing up to introduce our new App Studio in a Domo Alpha instance. We're inviting a select group of community members to get a firsthand experience of the new features and offer valuable feedback to our product team.
What is App Studio Alpha?
App Studio Alpha will be accessible in Alpha mode within a private instance. This exclusive access will allow you to explore and test the exciting new features firsthand. We’ll host a kickoff meeting during the week of August 28th where you'll receive access to the Alpha instance, which will contain only public and mock data, ensuring the highest level of data security and privacy.
How Can You Participate?
We're extending an invitation to you, to actively participate in the App Studio Alpha program. Your insights and feedback are invaluable in helping us refine and enhance the App Studio experience. To express your interest and secure your spot, simply sign up using this link:
What to Expect?
During the Alpha period, which spans approximately three to four weeks, you'll have the exclusive opportunity to immerse yourself in the App Studio experience. This is your chance to explore its functionalities, interact with its features, and provide us with product feedback. Your insights are important to enhancing and refining the App Studio's capabilities.
AnnaYardley