Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
kentwelcome opened this issue Mar 12, 2024 · 1 comment
Assignees

Comments

@kentwelcome
Copy link
Member

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 kentwelcome self-assigned this Mar 12, 2024
@popcornylu
Copy link
Contributor

popcornylu commented Mar 12, 2024

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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants