How to transform queries from different datasource (Mixed)

  • What Grafana version and what operating system are you using?

  • What are you trying to achieve?
    I have 2 graphite data source (active and backup). I’m trying to create a Mixed datasource and getting the data from both the DS and provide as a single panel.The reason why we are doing this is datasource 1 was not available for sometime, so if we select DS1 it will show a gap. So we want to get the data from both DS and merge them.

  • How are you trying to achieve it?
    Mixed Mode.

  • What happened?
    for example here is the query
    groupByNode(com.node.vm01.cpu*.idle, 4, ‘sum’) from DataSource 1
    groupByNode(com.node.vm01.cpu*.idle, 4, ‘sum’) from DataSource 2

when it renders in graana it shows both the output as expected. But the legends shows twice as they are 2 different queries . want to merge both of them into single. for example it returns for cpu-0 twice and i want to merge them both to single cpu-0.

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

Have you tried experimenting with the merge transformation?

This topic was automatically closed after 365 days. New replies are no longer allowed.