How to display multiple PromQL result in one table panel

I have two PromQL query as below:

mysql_global_variables_expire_logs_days{instance="$host"}
mysql_global_variables_innodb_flush_log_at_trx_commit{instance="$host"}

I want to display them in one table, the first column is metrics name, the second column is metrics value, but currently the best I can do is below, I’m unable to combine “Value #A” and “Value #B” into one column.
image
Is anyone know how to resolved it? I’m using Grafana v9.1.8.

Hi @liangli1213,

Welcome to the :grafana: community support forums !!

We are excited that you joined our OSS community. Please read about some of the FAQs in the community :slight_smile:

This could be possible using the Transformation function and in this specific case “Join by field” can help you.