How to display 3 queries output to one table in a panel(to have quick overview of alerts)

Grafana v8.4.0-Beta
datasource: Prometheus

  • What are you trying to achieve?

I am trying to achieve a display of two or more queries in one table in a panel. I would like the query to display an overview of every node. something like in the picture below:


  • How are you trying to achieve it?
    I am just new to Grafana, and what I tried to do is to select Table in visualization and add 3 queries separately. I tried to use transform but I did not get around it. see the image below:

  • What happened?
    What happened is, the dashboard does not display the table with the column as I expected. I tried to add an override in the setting but I can not see the column to edit.
    I know the query will filter only when the alert of the instance is in a firing state, but how to will I filter when in a normal state?

  • What did you expect to happen?
    I expect to have something similar to this below

Thanks in Advance