make avg column name upper case

Comments

1 comment

  • Official comment
    Avatar
    Ryan Johnson

    Hi Damian,

    You can enforce formatting by quoting your field name and prepending it with a percentage sign. For example:

    _sourceCategory=your/data
    | timeslice 1m
    | avg(_count) AS %"Average Number of Events per Minute"

    This will allow you to use a mixture of uppercase, lowercase, spaces, and special characters.

    In your case you would do something like this:

    | avg(transferRate_MBxS) AS %"Avg. Transfer Rate (MB/sec)"

    The thing you will need to keep in mind is any time you need to reference this field, you will have to do so with the quotes and percentage sign.

    I hope this helps :-)

    Ryan Johnson
    Sumo Logic, Australia

     

    Comment actions Permalink

Please sign in to leave a comment.