cube-js/cube

Add Support for relative time values for time filters

Open

#1,912 opened on Jan 27, 2021

View on GitHub
 (3 comments) (5 reactions) (0 assignees)Rust (19,563 stars) (1,965 forks)batch import
backend:serverhelp wanted

Description

Is your feature request related to a problem? Please describe. For timeDimensions we are able to specify relative values such as dateRange: 'Last 7 days'. It would be ideal if we were able to specify relative values for time filters as well.

Describe the solution you'd like To be able to define relative values such as 'Last 7 days' in both inDateRange and notInDateRange: https://cube.dev/docs/query-format#filters-operators-in-date-range and https://cube.dev/docs/query-format#filters-operators-not-in-date-range

Additional context Previous relevant discussion: https://github.com/cube-js/cube.js/issues/1737

Contributor guide

Tech stack
javascripttypescriptnodejsrest api
Domain
backendapianalytics
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Basic knowledge of Cube.js query formatFamiliarity with relative date rangesJavaScript/TypeScript development setup
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65
Research direction
Review the existing implementation of relative date ranges for timeDimensions (likely in the query parsing code). Examine the current implementation of inDateRange and notInDateRange filter operators in the Cube.js source code, particularly in files related to query transformation or schema compilation. Study the previous discussion in issue #1737 for context. Implement support for relative time values in the same manner as timeDimensions, ensuring consistency.
Add Support for relative time values for time filters · cube-js/cube#1912 | Good First Issue