Hi all, I am trying to build a query that only shows the NEW results compared to yesterday.
I would like to get some alert and data to show ONLY if the message/key is new today, compared to the results yesterday.
for example:
{query}
| stats count by key
Yesterday, the query returned - "key1", and "key2".
| key | count |
| key1 | 10 |
| key2 | 5 |
Today, there are some results returned - "key1", and "key3". I would like to get the count of "key3" only as it is new today and didn't show up yesterday.
| key | count |
| key3 | 15 |
Thanks in advance!
... View more