Hi @usamaaltaf420,
I think I understand this case from a previous post where the Transformation were not working. As an alternative, you can use Grafana’s Override function to achieve this.
I had replied to a post where I attached a .gif file which contains the steps as how to do it (in your case you may need some more modification with the “group_by” but I think should be possible).
Let us know if this helps. 