How can I create a percentage field in a table based on the count

Comments

2 comments

  • Avatar
    Rick Jury

    hi Greg,

     

    you can do eventstats in sumo just a different way.

     

    | avg(response_time) as Average, count as ResponseCount by response_code

    | total ResponseCount as totalresponses

    | (ResponseCount / totalresponses) * 100 as PercentageOfTransactions
    | sort PercentageOfTransactions
    | fields -totalresponses

     

    you could also use the format operator if you want to display it as a percentage with %

    0
    Comment actions Permalink
  • Avatar
    Greg Mantzaris

    Perfect Rick Jury.   Thanks!   Worked exactly as I wanted.

    0
    Comment actions Permalink

Please sign in to leave a comment.