Is there a way to visualize the frequency of values over some range? I'd like to see a histogram of counts.
In an attempt to generate a histogram, I wrote a quick query which buckets the values into intervals of 1000 (these counts range from 0 - 250k).
parse "[*]" as blah
| count by blah
| floor(_count / 1000) as bucket
| count by bucket
| sort by bucket asc
I'm able to produce something that looks like a histogram, but with missing sections of the x axis, since bins with 0 frequency aren't created.
Is there a better way to generate a histogram in Sumo Logic? I scoured the documentation but couldn't find anything relevant.
Please sign in to leave a comment.