Community Forums

Discover best practices and find answers to your questions with advice from fellow Domo users.

Recent Discussions

How can I create a beastmode that will return the desired substring in a field?
Hi all, I've given this multiple attempts and just can't seem to get it. I have a field called 'Destination' that I want to use in a Beastmode that will return the first substring of "B-FGI" or "FGI" in a value such as "Doe, John A-B-FGI-20.15.0003.B-FGI" or "Doe, John A-FGI-20.15.0003.B-FGI". I also want to create another…
Conditional Formatting - table MoM
Hello, I'm trying to set color rules/conditional formatting in a table card. What I'd like to do is set rules that if that months sales figure is higher than the previous it'll be green, if that months sales figures is lower than the previous it'll be red. (ex. If July sold 10, but Aug sold 8 August's value would show as…
How to create YTD, LYTD, LYLW, etc columns from a FISCAL CALENDAR
I have a dataset that has sales per item going by each week (yyyyww) for the last three years, only I can't use things like YEAR(CURDATE()) or YEARWEEK(CURDATE()) because the yearweek we're getting from the dataset is based on a fiscal calendar (Ex: The first full week of august is the first week of the year, so July 29,…
Company Turnover %
I am trying to calculate the company turn over %. We are pulling data from Salesforce into Domo. We have a custom object that lists all employees. These employee have an active/inactive status and a termination date. I am trying to figure out a way to calculate the total ACTIVE by INACTIVE YTD based on that term date.…
Compare to Industry Trends
Hi community, What's the best way to compare two different series when they are on totally different scales? My hope is to see if our trends compare to industry average. I've got month, year, our total, and the industry comparable. For instance: Date My Company Industry Jan-24 100 50000 24-Feb 150 60000 24-Mar 175 70000 I…
Solved ETL - Replace Null Values
Hi, I have a dataset with null values and text and I am trying to replace them with 0 and 1 respectively. But, when I try to write a formula using the conditions 'If Null' or 'If not null' I keep getting errors. Does anyone have any ideas? Thanks! Edit: I figured out what I was doing wrong.
Beast Mode - Grouping
Hi! I am trying to fix this beast mode calculation to group properly. I need the time to group 12am-6am and then show 7am-7pm as separate lines and then group 8pm-11:59pm. The opened date column i am using is in this format '2023-10-22T07:18:17' which is why I am trying to use the beast mode, but the grouping doesn't seem…
Tagging Customers on Services
Hi Community, excited to see what you think up! BLUF: How can I analyze what nurse saw a patient prior to a surgery or a non-surgery? See my simplified dataset below. My hope is to be able to see which nurses saw which patients/customers that led to a surgery (or not). My current thought is a CASE WHEN to create a label…
Calculation of previous dated values
I am trying to calculate trailing period (previous period) calc. I have year(variable selector), month(dropdown selector chart using column from table) If i select Year = 2024 and Month = Feb, I should get the data for 2024-JAN. Tried this formula but failing to get the correct figure. RecordDate(date format col) is…
Dynamic data comparison
Hi, I want to perform QTD, YTD without using Domo inbuilt features dynamically. Like, I will have a dropdown for Year using dropdown chart using the Year column from dataset. And variable selector for QTD, YTD. User may select any of the variable selector and any one year from the dropdown. Example: Variable Selector : QTD…

Welcome!

It looks like you're new here. Members get access to exclusive content, events and more. Sign in or register to get started.