-
Case when and formula with date
I'm writing the following formula and it's not distinguishing between the dates correctly. What am I doing wrong? case when `Parent OR AgencyName` = 'Aspire Home Healthcare' and `Date` >= '10/23/2024' then `Total referrals` = 0 ELSE `Total referrals` end Note, my date shows as the little calendar and 'Total referrals'…
-
Keep data in column as constant regardless of date
I have an ETL that includes a weekly upload of new information (employee name, quota, current sales) that is batched on Mondays. The quota is typically the same from week to week. When I use the information in a dashboard looking at last week, it doesn't recognize the quota since it's from the current week. Is there an ETL…
-
Map with GeoJSON coordinates
Hi - I have an CSV file with columns for identifying data (name, type, etc.) and then a column for GeoJSON polygon territory. Is there a way to put this into a visualization in DOMO?
-
US State Map - vary color by a dimension?
We're using the US state map to look at our staff by zip codes. Is there a way to have all staff on one map with each department as a different color?
-
Substitute for if / then statements
Hi - I'm trying to figure out the SQL code to sum (A) bill rate + (B) bill adjustment = Total Bill. However, Bill Rate can either be (A1) Original Bill Rate or (A2) Posted Bill Rate. Similarly, Bill Adjustment can either be (B1) Original Bill Adj or (B2) Posted Bill Adj. Logic is that If the (A2)Posted Bill Rate is NULL,…
-
Last week data
How do I sum a measure (activities) specifically for last week (Monday - Sunday) within ETL? I also would want to do for the week before. For context, my ultimate goal is to take an existing formula in ETL showing total potential activities for the week (which is constant) and then subtract the actual activities for the…
-
Beast mode calculation: Last compared to past average?
Hi - I'm trying to figure out the calculation to identify an action needed. I know how to do in Excel, but still learning the SQL / Beast Mode equivalent. I have a count of total items. If the count of total items from last week is 20% less than the average count of total items from the past 6 weeks, I want it to be marked…
-
Data on multiple lines
My data is showing on multiple lines even though the parameters are the same. For example, as shown below the area (Boca Del Ray) and the discipline (COTA) are the same, but it's showing separate lines with different data for the measures. I want each area and discipline to show only once. This happens throughout the full…
-
Connecting Monthly Goals to Incoming Cumulative Daily Data
I'm trying to create a card that shows cumulative daily sales against a monthly goal. The data is coming from 2 different sources - the daily info from our raw data, and the goals I was going to input as a webform to then connect with daily data. How do I get the "month" from my webform to match the cumulative raw daily…
