IGNORE NULLS not works in LAG Function

Question & Answer
,
1

I used lag function in amazon quicksight Direct query.
It is working if I use without IGNORE NULLS
LAG(Columnname,1) OVER (ORDER BY Timecolumn)

But It is not working If I use with IGNORE NULLS in the LAG function. I faced error while executing the query (Document Attached below)
LAG(Columnname,1) IGNORE NULLS OVER (ORDER BY Timecolumn)

Is the IGNORE NULL function not available in amazon quicksight?or my syntax is wrong?

image

2

@Marim ,

Here is the syntax for LAG Lag - Amazon QuickSight
Based on that I would say IGNORE NULL is not supported.

Kind regards,
Koushik

3

Thank you @Koushik_Muthanna