Best Of

Re: Freeze Page Pane

Love this idea it would be super powerful. I often find myself debating where to put filters on my dashboard or even if I want to create multiple filters of the same type for my users experience.

Freeze panes on key cards general would be a nice to have (not just filters), if I had a few 'master cards' that could always present at the top of the dashboard for users to eyeball as they go through/interact with the dashboard's journey it would be super useful. It would be a part of most of my dashboards I think.

G_Grey

1

Dynamic Pivot

I have a table with a combination of fields and a target value. I want to concat all the fields (Retailer, Field, Target, Strategic Priority) and pivot the table so they are all columns with their respective Target Value underneath.

I know how to do this with the Pivot option in which I manually create a new column for each combination. However, is there a way to have this automatically create new columns? My concern (beyond a whole bunch of manual input - I currently have 67 rows) is there will be rows (with new field combinations) added to this dataset and they'll be excluded unless I recognize and manually add them in.

Below is a screenshot of the data I'm working with for context.

NathanDorsch

1

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