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?