VSA "Total time chart" - add dynamic "Date Bucketing" (aka date grouping intervals)
Problem
Following the new VSA Overview "total time" Stacked Area Chart, we need to consider reducing the amount of data on the chart, to minimize the "noise" on a chart and to help user detect valuable insights from the data.
Daily data can be subject to hiccups and instability that may hide meaningful patterns or trends. Analyzing daily data might be too detailed with irrelevant noise caused by daily operational issues, random events, or outliers.
Today, the data points density is too high, and there is no limitations on the number of data series displayed on the chart:
As a result, it is difficult to understand and compare the data effectively. This can lead to confusion, and make it harder to identify important trends or patterns in the data.
Add bucketing to the VSA total time chart to provide users with the ability to visualize data using different date grouping intervals in the chart. (Aka dynamic data aggregation)
Implement dynamic data aggregation based on the selected bucketing interval. The number of data points and the number of days each data point represents should dynamically change according to the date range selected by the user.
When users switch between different date range, the chart should automatically aggregate data points accordingly.
The value of number of days each data point represents will be data aggregation of the average of all days in the bucket.
The chart should appropriately adjust the X-axis labels, gridlines, and data point density to provide a clear and intuitive visualization.
Pre-defined date bucketing intervals:
Chart date range - number of days
Date bucketing - number of days each data point represents
30
TBD
60
TBD
90
TBD
180
44
Last 180 days (current)
Last 180 days - bucketed into 44 data points (proposal)
Proposal B
Use data smoothing (7 day moving average) to reduce the noise.