I have a query that returns 0 records.
The query is also using a filter of "The last 12 hours".
I have 0 documents in the index, for the past 2 weeks, so the query is querying NULL(?).
SELECT COUNT(DISTINCT uuid.keyword) as count FROM (SELECT uuid.keyword, resolved.keyword, acknowledged.keyword, timestamp FROM "my-index*" WHERE x.keyword = 'x' ORDER BY timestamp_last_updated DESC) WHERE resolved.keyword = 'false' AND timestamp > NOW() - INTERVAL 5 MINUTES
When I look at the data preview, I see 0.
When I look at the visualisation on Canvas, I get an error icon.
Error due to missing documents:
Is this a bug? feature?
How can I show 0, in my case of 0 documents in the index?