[Grafana v7.5] Table Value Last (Not Null)

Hi community,

I haven’t worked with Grafana since version six and now have an issue with my latest Grafana table.

  • What is your Grafana version?
  • Are you using Grafana Cloud or self-hosted Grafana?
  • List the datasource associated with the alert

  • What Grafana version and what operating system are you using?

  • What are you trying to achieve?
    I merge multiple Prometheus queries into one table panel (instant option checked). But not all values are present at the same time (issue resides in Prometheus due to federation). However I remember there was a function to display the value as “Last (Not Null)”. I cannot manage to find it. Is this not possible with the table panel or is the feature gone?

  • What did you expect to happen?
    Fill in missing values with the last value.


welcome to the :grafana: forum, @christopherhans

you can find those calculation types in several places. Look in transformations tab. Several transformations use them:

You can also find them in the panel editor for the Stat panel.

Thank you. That helps a lot.