https://community.esri.com/t5/arcgis-dashboards-questions/category-selector-grouped-values-error-from-views/m-p/1007539#M4081 <P>I am trying to add a category selector using grouped values from a map service that contains SQL database views / query layers.&nbsp; When I choose the query layer from the map service, I get "No Data" results for the dropdown.&nbsp; Same result for any of the category fields in the query layer, string or number types.&nbsp;&nbsp;</P><P>When I click on the "Show data table" option, it says "No feature available".&nbsp; I can load categories however and override as seen in the image below.</P><P>However, the same process works for if I export the data and create a feature class from the query layer.&nbsp;&nbsp;</P><P>Anyone else with similar behavior?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Picture1.png" style="width: 538px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/1639iA0E0A43264C84AFF/image-size/large?v=v2&amp;px=999" role="button" title="Picture1.png" alt="Picture1.png" /></span></P><P>&nbsp;</P> Mon, 07 Dec 2020 21:18:15 GMT JohnLivengood 2020-12-07T21:18:15Z https://community.esri.com/t5/arcgis-dashboards-questions/category-selector-grouped-values-error-from-views/m-p/1007539#M4081 <P>I am trying to add a category selector using grouped values from a map service that contains SQL database views / query layers.&nbsp; When I choose the query layer from the map service, I get "No Data" results for the dropdown.&nbsp; Same result for any of the category fields in the query layer, string or number types.&nbsp;&nbsp;</P><P>When I click on the "Show data table" option, it says "No feature available".&nbsp; I can load categories however and override as seen in the image below.</P><P>However, the same process works for if I export the data and create a feature class from the query layer.&nbsp;&nbsp;</P><P>Anyone else with similar behavior?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Picture1.png" style="width: 538px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/1639iA0E0A43264C84AFF/image-size/large?v=v2&amp;px=999" role="button" title="Picture1.png" alt="Picture1.png" /></span></P><P>&nbsp;</P> Mon, 07 Dec 2020 21:18:15 GMT https://community.esri.com/t5/arcgis-dashboards-questions/category-selector-grouped-values-error-from-views/m-p/1007539#M4081 JohnLivengood 2020-12-07T21:18:15Z