Hi,
I have a data set like
Col A Col B
Time 5
Time 5
.
.
I want a new row with the total of Column B, something like
Col A Col B
Time 5
Time 5
Total 10
i know we can use addcoltotals but that adds a new column label.
Some input appreciated.
Thanks
Take a look at the following. I am filling in the word Total in the endhuman column at the end.
|gentimes start=-2 |fillnull value="blank" endhuman|addcoltotals|fillnull value="Total" endhuman|table endhuman,starttime,endtime,starthuman
Try | addcolTotals
Another way to get a column total, but it will be for each lines.
<mysearch> | table colA colB | eventstats sum(colB) AS total
Take a look at the following. I am filling in the word Total in the endhuman column at the end.
|gentimes start=-2 |fillnull value="blank" endhuman|addcoltotals|fillnull value="Total" endhuman|table endhuman,starttime,endtime,starthuman
Thanks Reed ... That worked ... 🙂
yeah .. tried that as well .. but that too gives output something like
Col A Col B
Time 5
Time 5
10
I need to show the Total Alias in the last row