Hello,
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.
Canvas:
Preview:
Error due to missing documents:
Is this a bug? feature?
How can I show 0, in my case of 0 documents in the index?
Cheers!