Date Range til yesterday
Hi there,
I have a calculation which compares daily sailes from this year to last year. Addionally YTD will be calculated and compared.
Unfortunately, DOMO includes today as the starting date, which is 0 and compares that figure to the relevant day in the last year.
Therefore I receive a wrong YTD in my last year.
Does someone has a solution? I don´t want to change the date range (Today-1) manually. I already changed my SQL flow and ETL so, I don´t have a partial sales for today, but I can´t figure out how to automatically exclude the day of last year for today (If that makes sense) eg.
This year: 22.1.2018 (no value)
Last year: 22.1.2017 (value)
Many thanks
Best Answer
-
I would just create a beastmode that will allow you to filter out today's date. You could then use this field to exlcude today's date and keep the date range as YTD.
You would just filter to exclude 'true' values
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman4
Answers
-
I would just create a beastmode that will allow you to filter out today's date. You could then use this field to exlcude today's date and keep the date range as YTD.
You would just filter to exclude 'true' values
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman4 -
+1 to Scott's idea. We use a version of this all the time.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thank you very much!
Thats a simple and effective solution.
0 -
Hi
Yes but when you compare YoY monthly totals on a YTD time range for instance, for the current month, today is valued at 0 which is what you want, but same day a year ago accounts for full. And the reports takes it into account because you are requesting a YTD report. So you end up comparing X days to X+1 which is meaningless. We should have a Year to Yesterday report as we have a year to date one.
Rgds
JM
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive