I am trying to filter a dataset because the data has a lot of inconsistencies and I do not want to get a misleading output. I want to filter the records where
freshness_status.fresh = freshness_status.stale and stalenessdays=null. And then after filtering the records, I want to create another field called, “parity”. But I do not want to modify the original dataset. I want to implement all of these in Grafana in order to customized output.
I would really appreciate some guidance on this.
I am not sure how