Creating a panel with results from a transformation

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    Grafana 7.x / FreeBSD13
    DS=Elasticsearch

  • What are you trying to achieve?
    I have a field called “email” e.g. michael@whatever.org - I would like to use a “rename by regex” transformation to only grab the TLD from the email address.

My regex looks like this:

match: .*@(.*)
replace: $1

It works - however I would like to create a pie chart grouping by this replace value.

My query is a count metric grouped by the email field.

However, the pie chart is not showing the grouped result.

Thanks,

Michael