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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive