Forum Discussion
Data filtering
So, when we're filtering all data from day, month, and year (selecting all function). Now, 5 out of 6 visuals are filtering data but 1 isn't doing that. Below attached is the query used for filteri...
DATESMTD & DATEADD are time intelligence function. Make sure your data model supports these time intelligence functions. For example, you need a continuous date column for these functions to work correctly. So please create a date table and reference the date column from that in your query.
can you please connect with us on google meet link? so we can better understand