Problem statement : Trying to create a dashboard for some data that I have sourced from Google Cloud Monitoring. I have all the required data but I am unable to transform it into my required view. I am attaching sample of what I have and what I am intending to do.
Follow these step to achive requirement.
Step 1: Create table and insert data in it. In my case I used postgresql to store data.
CREATE TABLE metrics (
id SERIAL PRIMARY KEY,
category VARCHAR(1) NOT NULL, – e.g., A, B, C
metric_type VARCHAR(20) NOT NULL, – e.g., Allocation, Utilization
value NUMERIC(10, 2) NOT NULL – Numeric value with two decimal places
);
Step 2: Select table Visualizations to display data on grafana panel.
Step 3: Now write queries to fetch data in my case 3 different query used to fetch data.
• Click on Add query for multiple query fetch according to your requirement.
o Query A
o Query B
o Query C
Step 4: Now apply transformations to visualized the data on table.
o Merge series/tables
o Transpose
Final output:
