Best Of
Re: Displaying Data on HTML Table with Pre-existing Formatting
I figured out a quick hack that works. Just posting here in case anyone else experiences the same issue.
I created a Beast Mode function to render, just by using a simple concat.
Now, when I reference my new field, it does what I need it to. I guess it just needs that little push to recognize the HTML?
Re: Adding Distribution List Column Value to Campaign for Each Email
I managed to figure out a solution for this problem. Basically, you can click on the "Add Merge Field" button and click on the field name to drag it to the location within the document or email body.
Re: If date falls within the current month
Hi @MThebeau
You may use the Domo Dimension.
Go to connectors and type dimension, It should look like the following screenshot
Re: If date falls within the current month
@MThebeau I would recommend restructuring your formula so that @colemenwilson's case statement resides within the denominator sum to ensure that all your conditions have the same granularity. Also MagicETL actually has a function in formula editor called DATE_WORKING_DIFF that calculates number of working days between two dates, so I would use that to hard-code the number of working days to date in the current month like this:
DATE_WORKING_DIFF(CURRENT_DATE(),CURRENT_DATE() - DAY(CURRENT_DATE()) + 1)
Then you can reference that new column in the final beast mode like this:
sum(`Total Billable Hours`)
/
sum(
case
when LAST_DAY(`Date`) = LAST_DAY(CURRENT_DATE()) then `MTD Working Days`
else `Working Days in Month`
end
)
Re: Filter Select: 2-day or 3-day data
Last 2 days:
CASE WHEN Date >= CURRENT_DATE() - INTERVAL 2 DAY AND Date != CURRENT_DATE() THEN 'Include'
ELSE 'Exclude' END
Last 3 days:
CASE WHEN Date >= CURRENT_DATE() - INTERVAL 3 DAY AND Date != CURRENT_DATE() THEN 'Include'
ELSE 'Exclude' END
Re: Filter Select: 2-day or 3-day data
You can use Michelle's suggestion to exclude today dynamically and then you can use the date range filter on the card and choose last 3 days or last 2 days, which can be easier to maintain and is an easier visual cue for the end user to know the data range of the card. It also allows them to change it to other date ranges, if needed, while still excluding today with the Michelle's beast mode.
5 Job Openings for Domo Users: July 16-22
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. See if you have the skills to pay the bills:
Favor Delivery-Business Analyst
In this role, you will leverage first- and third-party data to generate insights about customers, Runners, restaurant partners, and products.
- Salary: Not mentioned
- At least 2–4 years of experience working in an analytical role
- Experience with business intelligence software like Looker, Tableau, or Domo
Hearst Magazines-Business Intelligence Developer
We use both Domo and Looker in-house and we are looking for somebody to help build and manage the ads and revenue reporting models that exist in both of these tools. The ideal candidate is a capable developer within these tools, and can write, interpret, and optimize SQL across dialects.
- Salary: $85,000-$102,000
- 1-3+ years of experience in a similar role, preferably in a technology or media company.
- Use Looker’s LookML, Domo’s Dataflows, and other BI development platforms to build reporting models, to support the generation of actionable insights across ads and revenue analytics.
Telnyx-Growth Engineer, Revenue Operations
Work directly with Sales, Marketing, Customer Success, Support, & Product teams to drive mission-critical, cross-functional projects across the organization.
- Salary: Not mentioned
- Minimum of 1 year in Sales Operations/Sales Strategy or Revenue Operations
- Intermediate to advanced competence with Domo or BI tool with a passion for metrics and dashboards visualizations. Experience with SQL, Python, Javascript is a plus.
ABNB Federal Credit Union-Business Intelligence Developer
Provide technical expertise regarding data connectivity, data models, database design, report and dashboard development, data mining, and automation techniques.
- Salary: Not mentioned
- Three to five years of similar or related experience
- Experience with Domo and/or Tableau strongly desired.
Audacy-Senior Analyst, Insights & Analytics
Responsible for providing custom research insights and analytics support to Audacy’s direct to consumer business.
- Salary: Not mentioned
- 3+ years of experience
- Experienced with data visualization tools like Domo or Tableau
If you found this post helpful, LIKE AND SHARE THIS POST. Additionally, please tag anyone in the comments below who could find this digest useful.







