Hey guys! I need the statistics of a bunch of data by month. And this is done already. search |eval Month=strftime(_time,"%Y %m") | stats count(mydata) AS nobs, mean(mydata) as mean, min(mydata) as min by Month | reverse The output is what I want: Month nobs mean min 2023 06 1900 -5.0239778 -68.73417 2023 05 3562 -4.2430259 -67.134697 2023 04 3181 -4.1811658 -64.995394 2023 03 4274 -4.3373071 -134.20177 2023 02 3939 -4.7725011 -73.538274 2023 01 2868 -5.5231115 -41.056093 2022 12 395 -4.617424 -35.51642 Now I want to add another row at the bottom, called 'All', like this Month nobs mean min 2023 06 1900 -5.0239778 -68.73417 2023 05 3562 -4.2430259 -67.134697 2023 04 3181 -4.1811658 -64.995394 2023 03 4274 -4.3373071 -134.20177 2023 02 3939 -4.7725011 -73.538274 2023 01 2868 -5.5231115 -41.056093 2022 12 395 -4.617424 -35.51642 All z.zz x.xx y.yy Here, the result for x.xx, y.yy and z.zz should be from the whole search result, instead of from the statistics shown in the rows. I am wondering how to do that? Ideally, I can use the search result without the need to search again and degrade performance. Thanks!
... View more
