Forum Discussion
Direct Query not properly refreshing
I don't think the data should be refreshing at all. When you select the "Awaiting Diagnosis" the data is being filtered, so obviously the rows in the table will be different. The dashboard won't refresh in real time (unless they click the refresh button). If you need that functionality, you would need to look into streaming datasets.
To my knowledge, direct query means the data is querying live on interaction. Also of course the values will change when filtering, but if you look at the date column (ordered by date desc) you'll see that when unfiltered it shows an earlier date at the top of the table than when filtered (this should not happen as unfiltered should contain all dates).
So when i filter the dashboard correctly queries the db, and refreshes the data. When unfiltering, it goes back to the old data.
When i filter, the table shows a da