How to calculate proper average when long period with no data

[L0bit0]

Hi

This is my situation:

• I have a power meter for my home water heater.

• I have this scheduled to just start two times per day:
  

• But if I calculate average by day (mean) I feel Grafana just consider time while my device have measures.

• For example if one day it was working for 4 hours at 2 Kw/h, it will give an avg of 2kw/h , but if we consider the time was off, that should be 0 the avg for this day should be 0,6kw/h

• I tried with this option: No Value=0, but it looks works just for display, not for calculations
  

• Median also do not works.
  any idea about how to get realistic average/mean

thansk

[L0bit0]

Hi, let me update this as a reminder, nobody have any idea how to do this? do you need more details or clarity?

thansk in advance