apache / apache/superset

[SIP-116] Simplifying time period filtering for users

Open
#26,651 56 comments 13 reactions 1 assignee Claimed by @TechAuditBI View on GitHub
extension-candidate sip
Dominant language
Python
Stars
74.8k
Forks
18.3k
Avg merge
2d 5h
Merged PRs (30d)
685

Description

## [SIP-116] Proposal for simplifying time period filtering for users

### Motivation

Current time period filter is overly complicated and counterintuitive for users to work with. Yes, it does provide a lot of functionality and flexibility but it is not commonly used anyways.

### Proposed Change

Proposed change is to create an alternative time filter.

Current view of a proposed filter is something like a commonly used calendar date picker.
![Calendar picker](https://github.com/apache/superset/assets/88540994/1addc6aa-e011-4297-ad6a-d0fd778538ec)
Airbnb's picker for example.

The new date picker should replicate a currently existing functionality of fast navigation through months and years.

Open question is how to implement a time picker in a way that UI/UX stays simple and intuitive but functional at the same time. Current "scroll columns" design is good for touchscreens but is an absolute nightmare to use on a desktop.

A couple of examples of solutions found online:
https://www.cssscript.com/date-range-picker-predefined-ranges/

### New or Changed Public Interfaces

New time period native filter.
Otherwise unknown yet.

### New dependencies

Non known yet. Probably some UI lib.

### Migration Plan and Compatibility

None expected

### Rejected Alternatives

A time slider filter which would allow users to select time period for filtering simply by dragging a couple of markers across a slider.

Power BI slider for reference
![image](https://github.com/apache/superset/assets/88540994/8ff5c23f-9941-4079-8cce-0fcafaf5ef51)

Was rejected due to lack of visual information for user. But still could be achieved by improving "Number range" native filter.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.