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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive