그라파나 유사성찾기 3808

 

[walkAll] date 60d

avgtime 바꾸기 10~40

	WITH tmpMovingAVG AS (
		SELECT sum(walkAll) wall, heatDt, heatTm, devCd from KITETERA.dbo.tblHeatNeo 
		where compCd='3797' AND devCd='500'
		group by heatDt, heatTm, devCd
	) 
	select * FROM (
		SELECT CAST(heatDt+' '+heatTm+':00' as DATETIME) as [time], avg(wall) OVER (ORDER BY heatDt, heatTm ROWS BETWEEN $AVG_Time PRECEDING AND CURRENT ROW) AS M_24Hour_Avg
		FROM tmpMovingAVG
	) K order by [time]

22,23,24

 

[walkAll] 바꾸기 avg_time 23

walk1+walk2

walk1+walk2+walk3

walk1+walk2+walk3+walk4

walk1+walk2+walk3+walk4+walk5

walk1+walk2+walk3+walk4+walk5+walk6

walk1+walk2+walk3+walk4+walk5+walk7

walk1+walk2+walk3+walk4+walk5+walk7+walk8

walk1+walk2+walk3+walk4+walk5+walk7+walk8+walk9

XLXHYL

XLXHYLYH

XLXHYLYHZLZH

XLXHYLYHZLZH

 

sum(AVGRATE), avgwall + 100

	WITH tmpMovingAVG AS (
		SELECT sum(AVGRATE) wall, heatDt, heatTm, devCd from KITETERA.dbo.tblHeatNeo 
		where compCd='3797' AND devCd='500'
		group by heatDt, heatTm, devCd
	) 
	select * FROM (
		SELECT CAST(heatDt+' '+heatTm+':00' as DATETIME) as [time], avg(wall) OVER (ORDER BY heatDt, heatTm ROWS BETWEEN $AVG_Time PRECEDING AND CURRENT ROW) +100 AS AVGRATE22
		FROM tmpMovingAVG
	) K order by [time]

sum(walkAll)

	WITH tmpMovingAVG AS (
		SELECT sum(walkAll) wall, heatDt, heatTm, devCd from KITETERA.dbo.tblHeatNeo 
		where compCd='3797' AND devCd='500'
		group by heatDt, heatTm, devCd
	) 
	select * FROM (
		SELECT CAST(heatDt+' '+heatTm+':00' as DATETIME) as [time], ABS(avg(wall) OVER (ORDER BY heatDt, heatTm ROWS BETWEEN $AVG_Time PRECEDING AND CURRENT ROW))+400 AS AVGRATE24
		FROM tmpMovingAVG
	) K order by [time]