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...
...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...
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...
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