Best Of
I need syntax help. Bit of a newbie trying to teach themselves IF/LIKE/OR
The specific task is to identify if a truck is a F-250,350, 2500, or 3500. The Column is "model" that I'm looking for the partial match in the model column. I keep getting syntax errors.
CASE
WHEN
`model`LIKE ‘%F 250%’
OR `model` LIKE ‘%F-250%’
OR `model` LIKE ‘%F250%’
OR `model` LIKE ‘%E-350%’
OR `model` LIKE ‘%E-250%’
OR `model` LIKE ‘%2500%’
OR `model` LIKE ‘%3500%’
THEN 110
When `Actual bid 2` > 2500 THEN 120
ELSE 110
END
Just kidding never mind I fixed it.
I needed to use IN instead of LIKE
CASE
WHEN `model`IN ('%F 250%')
OR 'model' IN ('%F-250%')
OR 'model' IN ('%F250%')
OR 'model' IN ('%F-350%')
OR 'model' IN ('%F350%')
THEN 110
When `Actual bid 2` > 2500 THEN 120
ELSE 110
END
Re: View as user or view as role
@JordanJensen I think there's some assumptions built in to that question about the Domo Admin being an IT Admin or having the power to set up a service account / test account.
In addition to this, imagine what that would look like to validate the experience in Domo of in a hypothetical small 6 person Domo instance with you as CEO, and your CFO, CMO, COO, CTO, CIO… you would need to create the 7th test user, then need to add then remove all permissions to your test account each time you wanted to view someone's experience. Add CFO … remove CFO add CMO… remove CMO add COO… instead of having an ability to "view as" to ensure that they all have the expected Domo Interface.
The idea around restrictions and permissions, if you could blur or placeholder cards I don't think it would be an issue. Most of the time it would be helpful simply to quickly understand what it looks like when they visit a page. I do understand though that some companies have more restrictive controls around their data where this feature might just need to be completely disabled by a CSM / Superuser
Re: Custom Date & Timestamp Formatting in Analyzer View of Cards
This is an excellent writeup and welcome @Jonathan53891! @GrantStowell / @eddiesmall any thoughts on this being incorporated into the KB?
Re: Custom Date & Timestamp Formatting in Analyzer View of Cards
Great post! Thanks for documenting this for everyone!
Re: RANK Issues
@Marie_Serrano Each row/column combination used in a card are treated as a "row" from the perspective of the Limit Rows function. If you are using both rows and columns in a pivot table, then I suggest adding a Rank column in the MagicETL using the Rank & Window tile and filtering by that rank instead. The only drawback of this method is that the ranking will not dynamically change when users change the card filters.
Re: How can I calculate a percent of total in a Beast Mode?
Domo has these things called data label macros that might work for you here. Below is the link to their help section for data label macros.
http://wiki.domo.com/confluence/pages/viewpage.action?pageId=37454694
I'm assuming you're going to use a stacked bar chart to show the product % breakdown. If so, you can use the %_PERCENT_OF_CATEGORY macro which will automatically do this calculation for you. Once you've selectd the chart type and have added the x-axis, y-axis and the Series fields, go to Data Label Settings under chart properties and in the Text box, type in %_PERCENT_OF_CATEGORY in all caps and then tab out of the field and turn on your data labels by setting the Position and Justification fields. If you hover over that Text box, it will show you in a pop up what other macros are available.
This will do the calculation for you and will display it as the label on the chart and if you hover over the chart, it will still show your 'unit sales' values.
Godzilla
Re: Performance of private embedding
Hi @MattTheGuru thanks again for your prompt reply.
On point number 2. We have tested this in the past and can confirm that the dashboards embedded don't periodically refresh and also do not refresh (unlike boards on the instance) when the underlying dataset changes.
Yes agree I think we can just refresh an iframe in the background and swap it out. I had thought there would be a way with the js api where we could just apply filters perhaps with empty filters so the cards just refresh themselves.
Jones01
Re: Storing Projected Values
David,
This gives me some other approaches and thought. I really appreciate it.
Thank you,
Re: Performance of private embedding
@MattTheGuru Hi again.
We are going to go down the route of lazy loading the boards into iframe. If the iframe has been alive for a while we want to refresh the dashboard. Ideally we don't want to refresh the iframe itself.
Do you know of a simple way to just call refresh on all of the content? I assume via the js api?
I suppose we'd be looking to just reapply any filters selected so the data is updated.
Thanks
Jones01
5 Job Openings for Domo Users: January 29- February 4
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.
CMG Financial - Reporting Developer, Servicing Technology
This position will be primarily responsible development of servicing data requests from internal and external customers, which includes all servicing business lines, regulators, auditors, investor/insurers, executive leadership, and other key stakeholders. Partners with Servicing Data Business Analysts to ensure quality and rapid fulfillment of all requests.
- Experience required: 2+ years development and optimization of queries in SQL, Scala, Ruby, Python or similar
- 2-3 years of experience with web-based business intelligence tools such as Domo, Cognos, Tableau, Power BI, SSRS or similar
Hillsdale College - Digital Marketing Analyst
The Digital Marketing Analyst assists the digital marketing team with the day-to-day operations and reporting for college-wide and department-specific marketing initiatives. In addition, the Digital Marketing Analyst works with the Marketing Team on integrated marketing campaigns across multiple mediums and platforms.
- Experience required: 3-5 years of digital marketing experience with non-profit experience preferred.
- Prefer experience with DOMO, Tableau, Datorama, or similar dashboarding tools.
SharkNinja Operating LLC - Senior Digital Marketing Analyst
The role will encompass everything from data automation, visualization and delivering key insights to all levels of stakeholders to inform clear actions to be taken both within digital marketing and the wider DTC business, with a clear emphasis on story telling and joining the dots in a complex DTC marketing environment.
- Experience required: 3 + years previous experience working in an analytical role.
- Advanced data manipulation skills, strong Excel knowledge is essential, with other dashboarding tools such as DOMO, PowerBI advantageous.
Live Nation - Senior Marketing Analytics Analyst
Your role will involve working closely with cross-functional teams to interpret complex data sets, generate actionable recommendations, and drive continuous improvements in marketing efforts. The Senior Marketing Analytics Analyst will play a pivotal role in shaping marketing strategies, identifying growth opportunities, and enhancing overall business performance.
- Experience required: 4+ years of experience in analyzing and reporting on digital media channels and performance (paid search, paid social, programmatic display)
- Experience creating dashboards, authoring reporting and troubleshooting BI reporting and dashboard platforms such as DOMO, Tableau or similar tool
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. Strive to continually improve reporting systems and analysis capabilities for supported departments. This analyst position will heavily utilize SQL to do research and analysis.
- Experience required: 3-5 years office experience.
- 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.
If you found this helpful, LIKE AND SHARE THIS POST. Additionally, please tag anyone in the comments below who could find this digest useful.
