Hi,
I'm trying to find the cardinality of the fields for my indexes. The problem is that some fields sometimes have a value and sometimes they don't, so when I split with tstats/stats using the "by" clause, if one of the fields is empty, it returns nothing.
Example:
| tstats count where index=summary by host
works perfectly. But if I add the field "asset" which for the last 7 days has had no values:
| tstats count where index=summary by host, asset
it returns "No results found".
How can I make Splunk ignore that "asset" field so if it's empty it shows the data with rest of the splits?
Thank you.
... View more