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

Grafana Table Panel
,
1

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.

2

welcome to the :grafana: forum, @christopherhans

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

CleanShot 2022-03-17 at 09.27.58@2x
CleanShot 2022-03-17 at 09.27.58@2x1920×988 84.4 KB

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

3

Thank you. That helps a lot.