Allow Dynamic, Rolling Between Date Filtering in Charts
Idea:
Allow either the 'between' date range filter for charts to also allow selection of 'X months ago' to '2 months ago' (see second screenshot for current version), or have the 'Last' filter allow an "Exclude" last 'X" months option. (see first screenshot below)
Problem:
Needing to do date centered visualizations with some form of a cure period (Ex: I want to show the last year of data by month, but exclude the last 3 months. )
Currently you can only do that by :
1. Create a dynamic beast mode for every cure date use case using datediff from current date, and then use that to filter out the last 'x' months of data, and set the date range to the timeframe desired outside of that filter range. (Ex: Filter the chart to 1 year, but create a beast mode that assigns something as 'Less than 3 Months old' and '3+ Months Old", and then filter out data less that 3 months old)
2. select a fixed date range using between, requiring it to be manually updated if I want to have the up to date date after the cure period has passed:
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 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