How can I display data up to the last completed month
While at #DP18 I learned that for the sake of the "Corporate Executives" there is the ability to only display data thru the previous completed month rather than up to date. For example, my executive only wants to see, by default, revenue $ for January & February since thoses months are completed. March information would automatically appear when the calendar date equals April 1.
Anyone have any ideas how this can be done on the card (assuming via BeastMode) rather than restricting in the ETL/Dataflow?
Best Answer
-
The case provided did help however, it wasn't the exact solution i was looking for. I ended up going with the below statement for my exact need.
(CASE when `Date` <= LAST_DAY(DATE_SUB(CURRENT_DATE(),interval 1 month)) then 'Include'
else 'Exclude' end)
2
Answers
-
This might help you:
Case when Month(`your_date_field`) <= Month(current_date) - 1 and Year(`your_date_field`) = Year(current_date) then 'yes' else 'no' endPut this as a filter and check yes.
2 -
The case provided did help however, it wasn't the exact solution i was looking for. I ended up going with the below statement for my exact need.
(CASE when `Date` <= LAST_DAY(DATE_SUB(CURRENT_DATE(),interval 1 month)) then 'Include'
else 'Exclude' end)
2
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 9 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive