Populate cards at the start of a new month
Some of my datasets are populated only once weekly or monthly. When a new month starts all of my "current month" cards show "No data in filtered range". Is there a way to specify "most recent month" rather than current month? The idea is to populate cards with the latest month, regardless of if this is also the most recent month.
Thanks!
Best Answer
-
There's always the option of changing your cards from "This Month" to "Last Month" in the date filters, but a "Last Month" card may not be that valuable by the end of the next month. Easy/quick button would be to duplicate the card and set one to This Month and one to Last Month. The user could then make the judgement of which was more relevant to look at.
For something that would represent "latest month with data associated on it", you could do some ETL with a max function & grouping to identify the month/year with the most recent non-null value, and then beast filter just on that month/year.
Is there a timeframe or cutoff that the business uses when discussing last month or this month? Another method would be to setup some beasts & filters to show a certain timeframe depending on the day of the current month...you could set it to show last month data if current date was between the 1st and the 5th, and this month data if today's day was greater than the 5th. I think that can be just as confusing though for the person reading it if they're not aware of that cutoff.
1
Answers
-
There's always the option of changing your cards from "This Month" to "Last Month" in the date filters, but a "Last Month" card may not be that valuable by the end of the next month. Easy/quick button would be to duplicate the card and set one to This Month and one to Last Month. The user could then make the judgement of which was more relevant to look at.
For something that would represent "latest month with data associated on it", you could do some ETL with a max function & grouping to identify the month/year with the most recent non-null value, and then beast filter just on that month/year.
Is there a timeframe or cutoff that the business uses when discussing last month or this month? Another method would be to setup some beasts & filters to show a certain timeframe depending on the day of the current month...you could set it to show last month data if current date was between the 1st and the 5th, and this month data if today's day was greater than the 5th. I think that can be just as confusing though for the person reading it if they're not aware of that cutoff.
1 -
I've had a simliar issue when looking at some of our financial data. My solution was to create a webform that would allow me to indicate the Reported Year and Month. I then added this webform to my data set and I can use filters for `Date Field` = `Reported Date`
Hope that helps.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
This is an interesting solution, if I can't automate it I'll give this a try.
Thanks!
0 -
Thanks for your great ideas! I was able to make your second idea (using a Max Function & Grouping) work with the help of this other string on how to create a column with Max Date https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/ETL-Create-Column-with-Max-Date/m-p/20242/highlight/false#M2090
0 -
Nice! That's the way to do it! ?
Grouping is a wonderful piece of ETL. Any time you've got aggregations that you want to filter on in a card, just take it upstream and group it in magic.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive