I have a question regarding using Window Functions against the result set in redash querying against mongo db.
Below is my query, without the window function the query runs fine against the datasource. The Datasource result set is populated against the mongodb. Does redash support SQLite functions when we run query against the datasource result set?
SELECT label_workflowName, label_processId, label_instanceId, label_owner, label_activityName, label_assessmentType, label_activitiessubType, 'Recommendations_Provided' AS KeyField, value_Recommendations_provided AS ValuePair, lead(value_Recommendations_provided,1,0) Over(PARTITION BY label_instanceId Order BY label_processId,label_instanceId) LeadRank FROM Query_41 WHERE ValuePair IS NOT NULL Order by label_processId,label_instanceId