Hi @frostwar,
I believe you can accomplish what you want using the mixed datasource and then using transformations. You’ll need Grafana 7.x or higher.
check out this thread
and this thread
Grafana docs on transformation types
Grafana docs on mixed datasources