Combine 2 series in Time Series Panel

Grafana Dashboards
1

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

    Hello Guys I just want to combined the series I have into one series so that it will look like one Trend Graph, what happen is if I set the Group by month, time(31d) to get the “spread” (energy consumption) of my data, it split it into many series (which is per month, e.g. Jan, Feb, Mar and etc.), each series of course will have different colors which is annoying to see. Below is the example for month of Nov and Dec, you’ll notice that they have 2 different series but pertaining only on one measurement.

    image
    image1334×675 44.6 KB

I am thinking maybe there are transformation needed but I don’t know what kind of transformation. Hoping for your kind help. Thanks!

Weekly Community Recap - 8 Dec
2

Hi, have you tried the Merge transformation? If yes and it didn’t help, can you show how the data looks in the table format?