I will explain the context better with an Excel example. I have an accumulated energy meter, which sends me the accumulated energy every 5 minutes. To obtain the energy consumed in a certain time slot, simply work with differentials (instead of absolute values).
In this way, if, for example, you want the consumption that has occurred in a certain period of time, you simply have to subtract the values:
My question is whether this differential part can be done from the apex chart using the three fields that I mentioned previously and with the “transform” field in “difference”.
And what do these fields do? I would like to understand what do these fields do, for applying better my several situations. Do you know where could I find documentation about them?
For another hand, I am going to explain better the current context.
In your capture, it appears that you are selecting ‘mean, difference.’ Have you tried ‘max, difference’? In this case, it will take the greatest value of each data chunk and create the difference with the previous value.
It is right because in this case we are working with differential values, not with absolute values. We are subtracting the accumulated value of 12:00 (which is the maximum value of the 12:00 segment) from the accumulated value of 13:00 (which is the maximum value of the 13:00 segment). And if you look at the graph, since it is for each hour, it is correct. We are extracting the consume in one hour.
But if you zoom in and look at the graph for example every 10 minutes (X axis), it does not perform that post-processing again. It continues to be the maximum differential value from before: every hour (237.9) and not every 10 minutes.
