recce
recce copied to clipboard
[DRC-251] Design and implement Time-series Metrics to show the diff of Datetime columns
When we implemented the histogram diff chart, the histogram did support the DateTime
type in the beginning. However, we decided to remove Datetime
and implement a new kind of chart Time-series Metrics
for the Datetime
type.
In this chart, users can select a DateTime
column. Recce will show the time-series metrics based on the data in the selected column. Users can also select the time unit of the metrics by the frontend UI in Recce. (ex. year, month, week, day, hours, or mins, etc…)
From SyncLinear.com | DRC-251
In this story, we will implement the high-level UI to query the time-series diff (metric diff) in a model.
Use cases
- understand a datatime column distribution drift.
- compare the metric trend drift
Requirements
It would include these params
- model
- datetime column
- (Optional) tiimegrain (day, week, month, year). Default: auto
- (Optional) aggregation method (count, distinct count, sum, avg, min, max). Default: count
- (Optional) column to aggregate: Default: datetime column
Display the trend in a time-series chart. It contains two series (base, current)