Best Of

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

Re: YOY with Series

It sounds like you are trying to get 3 lines on top bars that are broken up into stacks of three? Besides being visually very busy, I'm afraid the lines would be difficult to interpret. A stacked bar is common practice, but with the lines, you'd either have to treat them as stacked, which would go against how lines are normally interpreted, or not stack them, which would conflict with the values in the bars.

Can you just make three copies of this bar/line YOY, one for each category, and maybe a fourth with the total? That would be less busy and less subject to misinterpretation.
Or, could you have just the total graph, but with a quick filter or a filter card to see it for a specific product category?

DavidChurchman

1

Re: Beast mode to select all the slicers

@chetan_cricut The Include/Exclude filter should not be a slicer, you would need to save it to every card on the dashboard so each card is filtered to ‘Include’.

MichelleH

1

Re: Get the most current run batch using Magic ETL, filter by batch?

Hi @verytiredgirl

I think you need to adjust your selection as

Date is in = Current Week

Last 1 week still looks at Aug 17 (Last Week)

Hope this helps

Godiepi

1