Any time that you use the stats command, anything that is not specifically called out in the by statement (for example | stats count by fieldx, fieldy, fieldz will no longer be part of your dataset. In the example you will only have fieldx, fieldy, and fieldz) if you want to keep your fields to be used after the stats command use the values command. | stats values(fielda) as fielda, values(fieldb) as fieldb count by fieldx, fieldy, fieldz Or | stats values(*) as * count by fieldx, fieldy, fieldz though values(*) as * is a lot more performance intensive than calling out the fields with values
... View more