Hi @kuul13 , you have two solutions that depend on how many data you have: 1) run three subsearches adding results to the same search using append: <your_search> earliest=-d@d latest=@d
| table <your_fields>
| append [ search
<your_search> earliest=-30d@d latest=-29d@d
| table <your_fields> ]
| append [ search
<your_search> earliest=-365d@d latest=-364d@d
| table <your_fields> ] I used table, but you can apply every output you like (e.g. timestamp, stats, etc...), obviously using the same in all subsearches. 2) classify events using eval: <your_search> earliest=-365d@d latest=@d
| eval period=case(
_time>now()-86400,"yesterday",
_time>now()-30*86400 AND _time>now()-29*86400,"last_month",
_time>now()-365*86400 AND _time>now()-364*86400,"last_year")
| table <your_fields> period I prefer the first solution that's faster, especially if you have many events. Ciao. Giuseppe
... View more