SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.

SigNoz Community

Hello Support Team,

I have few questions about aesthetics

1. We have a pie chart, we want to be able to customize color for each result, e.g green for success, red for invalid request, blue for pending request. How do we go about this
2. We have been able to use clickhouse query to get results, after looking at the query microservice, However we do not understand to use the clickhouse frontend timestamp for dynamic result. e.g 
```WHERE 
    timestamp >= 1738159136000000000 
    AND timestamp <= 1738162736000000000
    AND ts_bucket_start >= 1738157336 
    AND ts_bucket_start <= 1738162736

How do we represent timestamp and bucket using the frontend timestamp```
3. Could it be possible to convert query builder to clickhouse query vis the UI