- Katılım
- 23 Eki 2020
- Mesajlar
- 1,806
Pivot saatlik günlük haftalık
Kod:
LH:=valuewhen(1.,ROC(HOUR(),1,$)<0,REF(lowestsince(1., ROC(HOUR(),1,$)<0,L),-1));
HH:=valuewhen(1.,ROC(HOUR(),1,$)<0,REF(highestsince(1., ROC(HOUR(),1,$)<0,H),-1));
CH:=valuewhen(1.,ROC(HOUR(),1,$)<0,REF(C,-1));
PH:=(LH+HH+CH)/3;
LW:=valuewhen(1.,ROC(DAYOFWEEK(),1,$)<0,REF(lowestsince(1., ROC(DAYOFWEEK(),1,$)<0,L),-1));
HW:=valuewhen(1.,ROC(DAYOFWEEK(),1,$)<0,REF(highestsince(1., ROC(DAYOFWEEK(),1,$)<0,H),-1));
CW:=valuewhen(1.,ROC(DAYOFWEEK(),1,$)<0,REF(C,-1));
PW:=(LW+HW+CW)/3;
LM:=valuewhen(1.,ROC(DayOfMonth(),1,$)<0,REF(lowestsince(1., ROC(DayOfMonth(),1,$)<0,L),-1));
HM:=valuewhen(1.,ROC(DayOfMonth(),1,$)<0,REF(highestsince(1., ROC(DayOfMonth(),1,$)<0,H),-1));
CM:=valuewhen(1.,ROC(DayOfMonth(),1,$)<0,REF(C,-1));
PM:=(LM+HM+CM)/3;
PH;PW;PM