LAG and LEAD function

I used the LAG and LEAD function in community and it worked fine.  But when I used them while working on actual datasets (via a direct database connect), it seems that the functions are not available since the words lag and lead didn't turn red.  And the query give me a syntax errro.  

anyone able to use these functions while connecting to a database?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 7 mths agoLast active
  • 1Replies
  • 27Views
  • 2 Following