index=storage source="/******.csv"
| stats sum(00_) //It represents sum of various fields
| eval sum1=0
| foreach sum*
[ eval sum1=sum1+'<
| addinfo
| eval time_in_min=(info_max_time-info_min_time)/60
| eval sum1=sum1/time_in_min //It shows the average value
| fields sum1
I need timechart for sum1 with above data, is it possible ? Any help would be appreciated.
Thanks in Advance
The problem lies with the stats
and fields
commands. They stripped out the _time
field required by timechart
. Use streamstats
in place of stats
or find a way to include _time in stats
. Change fields sum1
to fields _time sum1
.
@shugup2923
Can you please share your search using code
block?