Best Of
Re: Better date selectors on cards
Hey @oscarfromspain
It's a few steps and if you use publication that adds a complexity.
To summaries:
- 4 date selection variable controls - bottom of dashboard page so users don't see it, all beast modes reference those
- Current Dates (Start & End)
- Comparison Dates (Stat & End)
- Custom DDX Brick that contains bulk javascript code that controls those variables based on the inputs in the brick controls this reference a DOMO Webform, but also builds the the calendar selection.
- DOMO Webform that contains ids of those variable controls mapped to some JS object that DDX brick references.
Thanks
Re: Better date selectors on cards
We had to build a custom date range brick that offered both options that controlled a series of variables.
Re: Domo Apps Home Page: Organization
Folders are officially under development! Folder structure for dashboards and apps — Domo Community Forum
kreid
Re: Folder for Organizing Apps in App Studio
Noting that something like this is now officially under development! Folder structure for dashboards and apps — Domo Community Forum
kreid
Re: Error "Domo task has exceeded the max number of runs (1000):java.lang.illegalstateexception"
It should be 1,000, and support can make it whatever you want…you just need to reach out to them.
Re: Activity Log doesn't Match Card Views??
The 710 number is within some time period, I can't remember what it is, but it IS NOT all time.
Correction: This documentation says that it is since card creation:
But above that section in the same documentation, the image shows views in last 30 days
So not sure when that changed and if it is all time or some other period. I would recommend submitting a Domo support case to get to the bottom of this!
Re: Beastmode For Prior Month, Current Month, Next Month, Month +2
forecast_date | run_date | forecast_value |
|---|---|---|
2025-07-15 | 2025-06-03 | $45.00 |
2025-07-15 | 2025-05-27 | $43.50 |
Month Category (which month)
CASE
WHEN MONTH(`forecast_date`) = MONTH(DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH))
AND YEAR(`forecast_date`) = YEAR(DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)) THEN 'Prior Month'
WHEN MONTH(`forecast_date`) = MONTH(CURRENT_DATE())
AND YEAR(`forecast_date`) = YEAR(CURRENT_DATE()) THEN 'Current Month'
WHEN MONTH(`forecast_date`) = MONTH(DATE_ADD(CURRENT_DATE(), INTERVAL 1 MONTH))
AND YEAR(`forecast_date`) = YEAR(DATE_ADD(CURRENT_DATE(), INTERVAL 1 MONTH)) THEN 'Next Month'
WHEN MONTH(`forecast_date`) = MONTH(DATE_ADD(CURRENT_DATE(), INTERVAL 2 MONTH))
AND YEAR(`forecast_date`) = YEAR(DATE_ADD(CURRENT_DATE(), INTERVAL 2 MONTH)) THEN 'Month +2'
ELSE 'Other'
END
Week Category (forecast was run this week or last week)
CASE
WHEN WEEK(`run_date`) = WEEK(CURRENT_DATE()) AND YEAR(`run_date`) = YEAR(CURRENT_DATE()) THEN 'Current Week'
WHEN WEEK(`run_date`) = WEEK(DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY))
AND YEAR(`run_date`) = YEAR(DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)) THEN 'Last Week'
ELSE 'Other'
END
Variance
`this_week_forecast` - `last_week_forecast`
And a pivot card to produce an output
forecast_date | Month Category | Current Week Forecast | Last Week Forecast | Variance |
|---|---|---|---|---|
2025-07-15 | Next Month | $45.00 | $43.50 | $1.50 |
Re: MAY we interest you in this month's top content?
Thank you all! I'm very excited for what's ahead and to learn more about the upcoming plans:)
Re: MAY we interest you in this month's top content?
Well deserved @ArborRose! You have absolutely been crushing the leaderboard. We are so happy to have you….
Also a huge congrats to our new coach @Manasi_Panov! For those curious what exciting perks are in store for our community coaches, STAY TUNED! We have HUGE things planned.
