On Value = 0 (zero) show last value instead

Hello,

  • What Grafana version and what operating system are you using?
    Grafana 9.0.6 on Debian 11
  • What is your datasource?
    InfluxDB
  • What are you trying to achieve?
    I am displaying fuel prices in a time series graph. During the night when some of the gas stations are closed the value of the gas price is shown as 0 (zero). Instead of displaying the zero value, I’d like to see the last value above 0 instead.
  • How are you trying to achieve it?
    not sure, maybe a transform that changes to last value if actual value is 0?
  • What happened?
    n/a
  • What did you expect to happen?
    Instead of displaying the zero value, I’d like to see the last value above 0 instead.
  • Can you copy/paste the configuration(s) that you are having problems with?
    2022-08-26 13_18_52-Clipboard
  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    no errors
  • Did you follow any online instructions? If so, what is the URL?
    did some googling, didn’t find what I needed

Thanks in advance

Cheers

Hi @kuddlowski,

Welcome to the :grafana: community support forums !!

Please review the submission template and include more details:

  • What Grafana version and what operating system are you using?
  • What is your datasource?
  • What are you trying to achieve?
  • How are you trying to achieve it?
  • What happened?
  • What did you expect to happen?
  • 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?

Thanks for the hint, I adjusted the initial post