How to merge the data in the table panel mode

Grafana
1

Hi Support,

I am looking for a solution to visualize my existing table panel mode in a different view.

Currently I have a dashboard using a table panel mode to see all the customer name and the critical alert count for each customer name. Prometheus is my data source. Below is the example dashboard

image

Now i would like to change the panel view to see the each customer name and it’s critical alert count together. here is the example

Blockquote image

Also I need to give a background of color of red if the alert count is more than 10 and green if the alert count is less than 5. My Grafana version is 7.3. Can somebody help me on this?