-
Notifications
You must be signed in to change notification settings - Fork 3.5k
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
API should support filling in zero values for group by intervals with no data #117
Comments
Nice work! I can confirm you that I was always doing this kind of thing client-side, that's a really helpful feature! |
This is indeed a nice feature, but currently it only fills zero values between min(time) and max(time) even if the query was looking at a larger time interval. i.e.: What happens is that the query returns 32 results (days between July 1st and AUgust 1st) instead of 365 as I would expect given the WHERE clause. |
We can't make this the default behavior. The default start time of the query is the lowest time that could be represented by an int64. If the user issued |
Thanks for your detailed explanation John - makes sense. Filling non-existing buckets with zeros on the client side works fine as well - was just surprised when I tested the fill(0) function. |
This is a thing we should support. See #426 to track progress. |
Heard this request and I don't think it's uncommon. Maybe something like this:
The second query should fill in zero values for every unique state it has seen so far.
The text was updated successfully, but these errors were encountered: