We have 2 tables from 2 databases mysql.
1er database : ‘acl’ and table ‘user’
2nd databse :‘content’ and table ‘desciprion’
In first database we have the table ‘user’ with this field :
id | name |
X234 | john
d234 | paul
In 2nd database we have the table ‘description’ with this field :
ident | content
id=X234 | xxxxx
id=d234 | xxxxx
id=x234 | xxxxx
With grafana we want to do a pie chart which :
count where id = ident and he display in pie chart the ‘name’ ( john )
typically with this example the result is :
2 for john
1 for paul
and in the pie chart we display : John and paul with count 2 and 1
is it possible ? if yes how ?
rgds