EXPLORE: gaps in date range in a query where there is no value
It would appear that Explore queries do not display a date in a sequence if there is no data on that date.
So, for example if there is no value for tickets on 9th October then in the query you will see in the date sequence for that month's data would display:
5 Oct nnn
6 Oct nnn
7 Oct nnn
8 Oct nnn
10 Oct nnn
11 Oct nnn etc.
* So as can be seen 9 Oct is missing *
This means that when data is extracted it gives a discontinuity and error ?
-
This is correct. Explore cannot show attributes where there is no data. If you are showing tickets by create date, if no tickets were created on Oct 9, there is no data in the database to show in your query.
There is some similar feedback here, if you want to expand on that or start some new feedback about needing to show continuity across dates: https://support.zendesk.com/hc/en-us/community/posts/360042149374--Explore-List-of-organizations-with-0-or-without-any-tickets-
Iniciar sesión para dejar un comentario.
1 Comentarios