Timeline pre-generated time bounds are not respected
The timeline form is loaded with a pre-defined time interval bounds, based on current hour. These bounds are then not used and the results are given for a superinterval since midnight before lower bound until midnight after upper bound.
Detection time from: 2020-06-30 15:00:00
Detection time to: 2020-07-07 15:00:00
SELECT generate_series('2020-06-30T00:00:00'::timestamp, '2020-07-08T00:00:00'::timestamp, '0 days 3600.000000 seconds'::interval) AS bucket ORDER BY bucket
The results match the time interval in the query, so the bounds as shown in the form are not respected.
Updated by Jan Mach about 1 month ago
- Status changed from New to Feedback
- Assignee changed from Jan Mach to Radko Krkoš
Radko Krkoš wrote in #note-1:
After more testing, this seems intentional, the interval is extended to a full week.
This indeed is a feature, not a bug. Whether it is optimal solution is up for a debate, since it got you confused, maybe the thresholds set by the user should be enforced. However the idea was to present user with nicely rounded time intervals, which means sometimes the thresholds need to be increased to be able to use nice time bucket sizes.