Hours on the Y-Axis? (Google Cloud Logging + Grafana)

  • What Grafana version and what operating system are you using?*
    I am currently working with Grafana v9.4.9

  • What are you trying to achieve?
    I want to create a time series panel with the following axis:
    – Y-Axis: Hours between 0 o’clock and 24 o’clock with format hh:mm:ss
    – X-Axis: Days in format dd/mm
    As shown in the illustration below:

  • How are you trying to achieve it?
    I tried to work with unix timestamps but the year and days are encoded in this value.

  • Explain your problem.
    I am working with googles cloud logging system that enables me to create my own metrics from log entries, but I can only filter numeric values. I don’t know how to encode hh:mm:ss into a numeric value in my log files, such that grafana could transform the numeric value into hh:mm:ss for the Y-Axis.

Is it even possible with grafana without developing my own plugin?

@greenteeworker Try the Apache ECharts panel. It allows the use of values as categories for both axes.

1 Like

Hey @mikhailvolkov ,

thanks for replying so fast with an possible solution. I will let you know if it worked or not.

1 Like