discover-labs/dictum

Change table transform

roveo opened this issue · 0 comments

roveo commented

alias diff?

select revenue, revenue.change() along (Year asc) within (genre)
by Year, genre

Argument means: change from what?

  • -1 (from previous value, default) revenue.change(-1) along (Year)
  • -4 (from -4 values) revenue.change(-4) along (Quarter) — quarters YoY
  • 'first' — from first value
  • 'last' — from last value