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 ?