Last X Periods to Date
I would like to add to the date filters on the to right corner of charts the following options:
- Life to Date
- Last [X] [Period] to Date
I have a dataset where a number exists for 'Max Business Date' each day. As the days pass, the number gets bigger until it reaches the total number of business days at the end of the month. i.e. June 3 =1, June 4 = 2, June 5 = 3. There are future dates in the dataset that I want to exclude. June has 19 business days, but I only want to see 3 because today is June 5. When I use any of the following date filers [week-to-date, month-to-date, quarter-to-date, year-to-date], I see the proper max business date for each month (May is 22, June is 3, July is excluded). However, when I use the following date ranges [Today, This Week, This Month, This Year], I see the max business dates per each month despite those being future dates. I want to be able to use date filters that allow me to see various time periods to-date (life, last X Y to date).
1. 'Life to Date' is pretty straightforward: show the entire dataset through today. This will function as the other to-date columns [week, month, quarter, year].
2. 'Last [X] [Period] to Date' is a combination of the existing functionality [for example, Last 13 Months] and the existing 'to-Date' functionality, as described above. I want to be able to filter the top right of any chart type to see the Last 13 Months to Date.
Thanks so much!
Jen
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 301 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 103 SQL DataFlows
- 628 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 756 Beast Mode
- 61 App Studio
- 41 Variables
- 695 Automate
- 179 Apps
- 456 APIs & Domo Developer
- 50 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive