Sum solar power sources to total - signal faults and calculated wrongly

  • What Grafana version and what operating system are you using?
    v10.1.2 on LXC container Proxmox 7.4.3

  • What are you trying to achieve?
    I have 3 different solar power sources and want to total the amount of generated power. Futhermore I want to display the SOC in the same chart.

  • How are you trying to achieve it?
    Using a time series panel with power on the left axis and SOC on the right axis. I have all values in the diagramm and I want to display all of them. But I want to add a curve with the total amount of solar power. With a transformation from the existing values I add a field from calculation (calculation = total).

  • What happened?

This leads to two issues:

First: SOC is calculated into the total and there seems no way to exclude it. The error is manageable but not ideal.

Second, even worse: I see regular power spikes on the total signal, that aren’t there in input signals, therefor it must come from the calculation. I assume it is due to an asynchronous feed of data among the different sources. But how can I fix this?

  • What did you expect to happen?
    SOC to be excluded from the operation and signal looking good without spikes.