Need help in data transformation in table panel

Grafana Table Panel
,
1

Please avoid posting in the Grafana parent category. Whenever possible choose a subcategory.

Hi team,
Currently we are trying to create table panel with below type of data:

| ResourceId | ResourceType | Region | CompliantStatus | ConfigRuleName |
Resource1 s3bucket eu-central-1 Compliant ConfigRule1
Resource2 s3bucket eu-central-1 Compliant ConfigRule2
Resource1 s3bucket eu-central-1 NonCompliant ConfigRule2
Resource1 s3bucket eu-central-1 Compliant ConfigRule3

we are expecting table to show below aggregated data
ResourceId, ResourceType, Region, CompliantStatus
Resource1 s3bucket eu-central-1 Compliant
Resource2 s3bucket eu-central-1 NonCompliant

Important point to consider here If resource2 has two CompliantStatus (complaint and noncompliant) then it should combine the data and should display only one record with noncompliant status

THANK YOU!!

~ the grafana team

2

So basically, it should eliminate compliant stat rows and only show non compliants stats rows?

3

Below is my requirement
1: If same resource has both compliant and noncompliant records, then it should display non-compliant records only and should not display compliant records for same resource.
2: If same resource has only non-complaint records, then only show one records for same resource with non-complaint status.
2: If same resource has only complaint records, then only show one records for same resource with complaint status.

1 Like
4

Waiting for your response