How to create a histogram grouped by a tag

Grafana InfluxDB
1

  • What Grafana version and what operating system are you using?
    Arch, version: 11.2.2, commit: c47b921ef40

  • What are you trying to achieve?
    I have an InfluxDB table that stores stats about my web server, specifically:
    (timestamp, ms, path)

I would like to create a histogram that shows all paths separately. On top of that, I’d like to add all items over 100ms into one rightmost bucket.

  • How are you trying to achieve it?
    I’m using the histogram visualization
    I query the data as SELECT "ms" FROM "request_ms" WHERE $timeFilter GROUP BY "path"
    I set the alias to $tag_path
    I set the max value to 100
    I set the unit to Time / ms

  • What happened?
    The histogram looks mostly ok
    The histogram ignores any values over 100ms (and if I don’t, a single large value makes everything else illegilible)
    The x axis uses the correct unit
    The y axis uses the correct unit
    The hover tooltips use millisecond for the counts. I see 3.03s when there are ~3030 instances of POST /api/v1/ping in the 0-10ms bucket

image
image314×349 14.1 KB

  • What did you expect to happen?
    I expected everything over 100ms to go into the rightmost bucket
    I expected to have the histogram count use numbers as the unit

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?