I have the following search and am looking to display its results over the past 30 days. It currently shows the results but only the current day is accurate. Any advice would be much appreciated...
index=data NOT ID="" earliest=-30d@d latest=now|regex name!="[a-z]."|dedup id2|timechart span=1d count
You probably don't need dedup
. Try this search:
index=data NOT ID="" earliest=-30d@d latest=now|regex name!="[a-z]."|timechart span=1d dc(id2) as count
It currently shows the results but but only the current day is accurate///
more details required.. may we know how you say that only current day is accurate, the older day logs are loaded properly or any issues?!?!
I believe there is something wrong with the dedup. Today shows the correct value and the day before shows a number, in this case 3. When I remove dedup all the results are off by 3.
Is there any way I can break up the search to make it dedup by one day at a time not across the whole thing?