Is it possible to have an ongoing card date range that reflects YTD, minus the current month?
I am looking for a way to show our monthly totals (Income, Expense, NOI, etc.) Year to Date, minus the current month. It takes our company a couple weeks to formally "close out" the previous month. So current months' #s aren't relevent until then. I'd prefer to just not show the current month, as that data skews the analysis without further filtering. I'm trying to make it easier for Managers to see relevant totals without needing to drill.
Comments
-
Hi,
You can create a beastmode to bring into your filters to eliminate the current month from showing. Something like the below.
case when `your_date` = DATE(DATE_FORMAT(CURRENT_DATE,'%Y-%m-01')) then 'TRUE' else 'FALSE' end
Then you can just filter for "False" and it will show YTD minus the current month
Best,
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
This is the solution Customer Support provided. Very similar to your suggestion. Thank you! These do the trick.
CASE
WHEN MONTH(`date`) = MONTH(CURDATE())
THEN 'Current_Month'
ELSE 'Previous_Months'
END0 -
Yes, that will also work for your question. Just be weary that if you are looking at the last 13 months and trying to remove the current month, you wouldn't want to just use a month match as that would be get rid of your August data in both 2018 and 2017.
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 762 Beast Mode
- 65 App Studio
- 42 Variables
- 704 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 133 Manage
- 130 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive