I would like to show MOST RECENT data in my dashboard. (Using most recent date, not today's date, MOst recent date can vary) I already have feature service layers in my map that are in SDE (SQL Server) which have definition queries to only show most recent data. Works fine in a map but NO dashboards elements will work with these layers - the elements simply don't show any data - a small warning sign is displayed in the element and when i hover over it it says "Cannot Access Data" and the element says "No Data"
The workaround would be to NOT use a definition query in the feature layers in the map and filter the data using MOST RECENT DATE in the Dashboard. But "Latest", "Most Recent", "Max" for a date field is not an option.
Any ideas for a workaround? My definition query in the feature layers relies on the fact that the back-end database is an SQL Server so "Date_Field IN (SELECT max( Date_Field ) FROM Feature_Class_Name" query works. However this query would not work in FGDB. Is there any way to make it work in my Dashboard or any other workaround that can display my dashboard data using the MOST RECENT DATE?
Screen capture shows indicator element not being able to access data from a layer that has a "max date" definition query defined: