Best Of

Re: Smart Text in Card Titles not displaying on the dashboard

I have a similar support case open right now. Smart Text is showing the wrong value with global date filters on apps. I would recommend submitting a support case with Domo Support.

ColemenWilson

2

Re: Join the Slack Domo User Group!

Interesting… I see a lot of great engagement on the Slack. It also seems like a lot of the help requests have shifted to Slack. I wonder in the long run if that will make it harder for people to Google answers to questions that have already been asked.

DavidChurchman

2

Re: Checkbox, last 3 months, last 6 months

I would use the variables feature to accomplish. You would want to use the radio button control in the variable creation and create two options: Last 3 months and Last 6 months.

Then, create a beast mode that looks to see which option is selected by the user:

CASE WHEN variablename = 'Last 3 months' THEN
CASE WHEN UTC_DATE >= DATE_SUB(CURDATE(), INTERVAL 3 MONTH) THEN 'Include' ELSE 'Exclude' END
WHEN variablename = 'Last 6 months' THEN
CASE WHEN UTC_DATE >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH) THEN 'Include' ELSE 'Exclude' END
END

Add this beast mode to your filter and filter to Include. This should allow the user to select their date range and the card will dynamically change.

MarkSnodgrass

1

Re: How can I get null/empty string fields to appear as zeros in my ETL?

I would use a "Value Mapper" tile for this, like so:

Obviously you'll have to change the 1st field to search the relevant column in your dataset.

Let me know if this works :)

Data_Devon

2

Re: How can I get null/empty string fields to appear as zeros in my ETL?

You can use COALESCE and NULLIF.

COALESCE(NULLIF(TRIM(`Quantity`), ''), 0)

GrantSmith

2

Re: DataBricks - Data Freshness & Data Caching.

https://domo-support.domo.com/s/article/4412849158167?language=en_US

https://www.domo.com/blog/how-to-optimize-data-warehouse-strategy-with-cloud-amplifier

These are the only documentation links I can find.

Feature	Purpose & Behavior
Data Freshness	Checks whether underlying data in the warehouse has changed—triggers reload, alerts, or on-demand refresh.
Data Caching (TTL)	Temporarily stores previous query results to avoid unnecessary compute; automatically expires after time or data change.

Freshness checks evaluate whether data changed; caching stores query results and helps reduce compute cost and latency. They work in tandem but serve different roles.

According to the blog, Cloud Amplifier issues freshness-check queries (like querying information_schema) periodically—by default every 15 minutes—to determine if source data in your cloud warehouse (e.g., Databricks) has changed.

It uses these to:

• Decide whether to trigger ETL flows in Domo.

• Trigger dataset alerts.

• Determine if on-demand queries should hit the warehouse again or can be served from cache.

ArborRose

1

Re: Rank function in Beast Mode

I have received that message as well. It is actually potentially just a warning. If you save and close the beast mode and use it, it can still work. Did you

MarkSnodgrass

1

Re: Displaying `% Change` based on `Date` Beast Modes (Prev Month YoY and Last 2 Months MoM)

For percent of change in formula, you can create something like

(

 SUM(CASE WHEN YEAR(Date) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))

           AND MONTH(Date) = MONTH(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))

     THEN Volume END)

-

 SUM(CASE WHEN YEAR(Date) = YEAR(DATE_SUB(CURDATE(), INTERVAL 13 MONTH))

           AND MONTH(Date) = MONTH(DATE_SUB(CURDATE(), INTERVAL 13 MONTH))

     THEN Volume END)

)

/

 SUM(CASE WHEN YEAR(Date) = YEAR(DATE_SUB(CURDATE(), INTERVAL 13 MONTH))

           AND MONTH(Date) = MONTH(DATE_SUB(CURDATE(), INTERVAL 13 MONTH))

     THEN Volume END)

But you don't need to do all the work with formulas, let analyzer

ArborRose

1

Re: Refresh Metadata?

If you're looking for manual refreshes, they are available in the Domo Stats connector (Activity Log report). It includes the user who initiated the manual refresh, etc. If you're looking for something more comprehensive, there are a number of reports in that connector, and I'm sure one can provide what you're looking for.

KM_Eccles

1

Re: Can Net Income calculation be created in dataflow?

Summary:

Use single quotes (' ') for text values.

Use backticks ( ) for field names.

Examples:

Comparing a field to a text value:

CASE WHEN Status = 'Active' THEN 1 ELSE 0 END

Using a field with spaces in its name:

SUM(`Order Amount`)

Mixing both together:

CASE WHEN `Category` = 'Clothing' THEN `Sales` ELSE 0 END

ArborRose

2