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?