I am looking to get the data in year, month, day, hour, minute and second basis search criteria is index="abc" rex field=raw"few fields" | stats count yearcount by year The above query is giving me below columns year yearcount 2023 10 Similar to the above query we want to get count of month, day...seconds the final output should have below table year yearcount month monthcount day daycount ......seconds secondscount Is it possible to get this output without using appendcols function multiple time as it is making the search query very long and not effective.
... View more