Hi, I want to get the count of errors. So i have a query to get the count by status where status is greater than 400. When i use addcoltotals, it is thinking status as a column and hence it is g...
I have used the below query to get the total from that column Index="" source="" | fields queryHits | table queryHits | addcoltotals labelfield=total label="queryHits"... Now how do i g...
How to use addcoltotals to calculate percentage? For example: my search below scoreSum % is empty Thank you for your help index=test | stats sum(score) as scoreSum by v...
Hi,
I have a table that gives me connections, and I want to show those connections, plus a total. The search works, but how do I get a name for the total row?
The output looks like this:
HO...
Can you leverage the total derived using the addcoltotals command to support other calculations? i.e. can you use it to calculate a percentage? | addcoltotals count labelfield="total" | e...
...om) as com by field1, year| addcoltotals o/p: field1 com 2019 2020 2021 for this total for 2020 is correct but facing issue for 2019 & 2021 please help me to get correct solution for t...
Hi,
I have a file like :
XXXX 20
YYYY 40
ZZZZ 60
I am running a query ....|addcoltotals
I am getting :
XXXX 20
YYYY 40
ZZZZ 60
120
but I also want to mention G...
I am trying to add a percentage to the total row generated by addcoltotals. I would like to show the total percentage of successes for a search using top. addcoltotals seems to only perform a sum a...
Hello,
I'd like to do the following (screenshot at http://hpics.li/49c6c08), do not sum percentages but just following a calculation rule.
Thanks for your help.
Screenshot