Hi all, I have some data in different timestamps as below image, imaging that the fields are "src label", "src value" "dst label" , "dst value" and timestamp.
how can I define a new fields named as "In" based on the above data in a time range?
the target "In" field for each specific label will be calculated base on the sum of "src value" and "dst value" of each document which respectively their "src label" and "dst label" is the mentioned specific value as below:
for example the "In" value for label= Inf in a time range is calculated based on the sum of "src value" for those "src label" which are equal to "Inf" and sum of "dst value" for those "dst label" which are equal to "Inf" in the requested time range:
In=12000+10+500+1900+915=15325
same as "In" for "Inf" label, the "In" value for "Tst" and "Pst" labels should be as below:
In (for Tst)= 450+201+540+756=1947
In (for Pst)= 104+112+814=1030
and finally I want to have a visualize table same as below image in the desired time range:
any help will be so appreciated
Regards