Hello,
We're using the TSVB visualization in Kibana to display calculated rates over time using the Filter Ratio aggregation within a time series.
We prefer to analyze our data on a weekly basis (sun–sat). However, when we set the interval to 1w in TSVB, the data is aggregated from Monday to Sunday instead.
In Stack Management, we've set the "week start" to Sunday, but this only seems to affect how the data is displayed in the frontend (e.g., we can see plots starting from Sunday). The actual aggregation buckets still start on Monday, meaning the weekly data is offset by one day.
We’ve also tried using the "Offset series time" option in TSVB. While this does shift the data on the x-axis, it doesn't actually change the aggregation range since it still aggregates data from Monday to Sunday, just displayed differently.
What we need is a way to configure ES or TSVB so that the weekly aggregation buckets align with sun-sat, not mon-sun.
Is there a way to accomplish this for our use case of viewing calculated rates over time?
Thanks in advance!