Grafana to Send out alerts on Transformed value


Is there a way we can send out alert on a transformed value?

right now I have Google Cloud API - MQL returning

State and filename - Now just because there is duplicity in state I was hoping to apply distinct on state and filename - unfortunately whenever a new log is detected Grafana also get’s a new time added and when we execute MQL with group by on state and filename it separates the value because of Grafana added TimeStamp.

I was hoping if we could exclude this timestamp to only focus on Distinct of state and filename.

Let me know if there’s any suggestion.