Extract in Panel resilience4j_circuitbreaker_state

[marcoberri]

Bug description

Hi, I have a problem displaying string information in the details panel widget
The data extracted from the db

SELECT last_value(JSONExtractString(labels, 'state'))
FROM signoz_metrics.distributed_time_series_v4 where metric_name ='resilience4j_circuitbreaker_state'

result

half_open

query result db line

│ backend-xxx│ Unspecified │ resilience4j_circuitbreaker_state │ The states of the circuit breaker │ │ Gauge │ false │ xxx│ xxx│ {"__name__":"resilience4j_circuitbreaker_state","__temporality__":"Unspecified","application":"xxx","container_id":"xxxxxx","deployment_environment":"xxx-xxxx","environment":"xxx-xxx","host_arch":"amd64","host_name":"xxx-xxx-xxx.xxx","name":"xx","os_description":"Linux 5.4.0-148-generic","os_type":"linux","process_command_line":"xxxx","process_executable_path":"xx","process_pid":"1","process_runtime_description":"xx","process_runtime_name":"OpenJDK Runtime Environment","process_runtime_version":"21.0.4+7-LTS","service_instance_id":"xxx","service_name":"xxx","service_namespace":"ms/xxx","service_version":"xxx","state":"forced_open","telemetry_auto_version":"1.33.4","telemetry_sdk_language":"java","telemetry_sdk_name":"opentelemetry","telemetry_sdk_version":"1.39.0"} │

why 0.167 ?
How to extract .state attribute (value in example is 'forced_open')?

Version information

• v0.52.0:

tnx!

[srikanthccv]

The value type panel doesn't support displaying string information. It is built to show the result of an aggregation. We plan to add support for the text type panel.