Splitting a table in a panel

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    I am using 10.4.19,windows

  • What are you trying to achieve?
    I am trying to split a table in panel in to multiple tables.
    I need to split a table which is populated using promethes as a datasource.I need to split some columns in to two tables so that can be uded for my requirement.
    Is it possible to split the table derived from a metric? If possible what are the transformations Needs to be used.Can you please help me in this.
    Thank you

2

I am looking to split according to columns.If a table contains 5 columns. Two columns should be under one table and other two columns under other table

3

Hi @nawinchappidi,

You can resolve your issue by following the steps outlined below.

Step 1. Start the Prometheus server.

Step 2. Integrate Prometheus as a data source in Grafana.

Step 3. Write a PromQL query to fetch the data in a table format with multiple column.

nalytics_summaries_rollup_duration_seconds_count{job="grafana"} 
or analytics_summaries_buffer_size{job="grafana"} 
or analytics_summaries_rollup_duration_seconds_sum{job="grafana"} 
or analytics_summaries_rollup_previous_time{job="grafana"} 
or deprecated_flags_inuse_total{job="grafana"}

Step 4. Apply the transformation to organize the data into columns by selecting or deselecting the appropriate labels.

image
image544×211 14.8 KB

Final ouput :

image
image1103×553 54.9 KB
)

image
image1105×561 48.7 KB
)

image
image1102×559 46.6 KB
)

Note: This solution requires two panels for implementation.

4

Hi @infofcc3 Thanks for the reply.
My requirement is to divide the table according to columns in the same panel where the prometheus metric table populated.Is that possible?

5

Hi @infofcc3 , Any inputs for the above Query

6

you could try some html using Business Text Grafana plugin

image
image1671×621 86.1 KB