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

[christopherhans]

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?
  7.5.11
• Are you using Grafana Cloud or self-hosted Grafana?
  self-hosted
• List the datasource associated with the alert
  Prometheus

→

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

• 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.

TY&BR
Chris.

[mattabrams]

welcome to the 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.

[christopherhans]

Thank you. That helps a lot.