recce icon indicating copy to clipboard operation
recce copied to clipboard

[DRC-251] Design and implement Time-series Metrics to show the diff of Datetime columns

Open kentwelcome opened this issue 11 months ago • 1 comments

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

kentwelcome avatar Mar 12 '24 01:03 kentwelcome

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)

popcornylu avatar Mar 12 '24 01:03 popcornylu