Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. TagId, sdata
  2. 8862, [0,0,0,0,2,2,2,3,4]
  3. 6304, [0,0,0,0,2,2,2,3,4]
  4.  
  5. TestTable
  6. | where TagId in (8862,6304)
  7. | make-series sdata = avg(todouble(Value)) default=0 on TimeStamp in range (datetime(2019-06-27), datetime(2019-06-29), 1m) by TagId
  8. | as S1;
  9. S1 | project ddata = series_divide(sdata[0].['sdata'], sdata[1].['sdata'])
  10. | as S2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement