Random or every Nth value

Comments

1 comment

  • Official comment
    Avatar
    Graham Watts

    Hi Chris,

    On method for sampling results in a query is parsing out the timestamp. You can use parse regex, for example, to parse the number for hours, minutes, and seconds.

    If you have a timestamp with 12:07:22, you can then write a where statement to filter on and sample specific values for hours, minutes, or seconds. For example:

        | where seconds matches "1*" OR seconds matches "3*" seconds matches "5*" 

    Is this what you're looking for?

    Comment actions Permalink

Please sign in to leave a comment.