we have created the date indicator using
CASE WHEN getday(d.Date) <= getday(now()) THEN 1
END AS isMTD
however, if we use this as a filter on a dashboard or widget it does not work? It does not change the filtering on the widget and it does not automatically change the date.
We have had issues with the date format changing when we load .csv files and I am not sure this is the cause
Adi is our OBP consultant
Please can we have some assistance?
Please sign in to leave a comment.