You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2019/05/28 19:37:25 UTC

[GitHub] [incubator-superset] vylc opened a new issue #7604: [SIP-22] Proposal for changes to time filter to allow for more flexible time range selections

vylc opened a new issue #7604: [SIP-22] Proposal for changes to time filter to allow for more flexible time range selections
URL: https://github.com/apache/incubator-superset/issues/7604

## [SIP] Proposal for changes to time filter to allow for more flexible time range selections

### Motivation
Time is a first order dimension and the primary way to filter datasets. A few issues that need to be resolved:

1. It is currently impossible to specify commonly filtered time ranges on recurring charts and dashboards. (ie. last full week, etc.)
2. It is unclear to users what time ranges are being specified
3. Date ranges are conflated with date+time ranges

Currently in Superset, there are a few different ways to specify a time range for a set of data in Explore View:
<img width="227" alt="Screen Shot 2019-05-21 at 1 34 11 PM" src="https://user-images.githubusercontent.com/33429480/58506297-d18d4880-8143-11e9-9e93-0350557c1270.png">
#### On the ‘Defaults’ tab, there are a few options here:
1. No filter - no specified range; return all data
2. All other options are presets filtering on time ranges relative to today. The units of time referenced here convert to # of days. For example:
- Week = 7 days
- Month = 30 days
- Quarter = 90 days
- Year = 365 days

<img width="225" alt="Screen Shot 2019-05-21 at 1 34 46 PM" src="https://user-images.githubusercontent.com/33429480/58506319-e7027280-8143-11e9-915a-bc8a110909e5.png">
#### On the ‘Custom’ tab, there are 2 options:
1. Relative to today is similar to Defaults, however this is flexible enough historical and future looking as well as controls on units of time
2. Start/End is pretty self explanatory. The one notable element here is the ability to use English to express time; however this is somewhat limited
#### All date/time ranges start at 00:00:00 time

### Proposed Change
The main issues we need to solve are:
- Ability to specify relative dates that are not relative to today
- Ability to specify start of time units
- Clearly display time ranges being filtered for
(Nice to have - improve usability by adding more common default time ranges)

#### Changes to Defaults tab

1. Modify Defaults tab to organize by unit of time
2. Add clarifying time range selected
3. Augment default time ranges
4. Add Week Start Date
5. Modify months to be interpreted as calendar months (otherwise use weeks)

#### Changes to Custom tab
Mostly, the same with the following modifications:

1. Add ability to anchor to specific date (defaulted to Today)
2. Show selected time range
3. Keep ability to do “english” language times (ie. 6 hours ago, now, etc. through Start/End dates)

### New or Changed Public Interfaces
- Will need to keep superset tables that at minimum contain calendar months (ie. how many days in each month, etc.) if not standard time tables if eventually we want to get fancier with time ranges

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org