Include a table chart for analysis
We have the donut chart but it would also be useful to be able to add a table chart as well - while this displays the same sort of data - it can be interpreted faster.
With the Number of ArcGIS Server Services by Type example at https://www.esri.com/arcgis-blog/products/monitor/administration/5-useful-arcgis-server-analysis-ele... - it does this in a graphical form but you have to highlight over the donut section to get the count - and would have to include the server name in the title or the like. You'd need multiple charts for multiple servers - but being able to have a table would also be useful for some items.
In addition to having the query builder - it would also be useful to have custom SQL queries so we could build more custom queries - I think this has already been suggested - but we could do things like (please excuse my basic sql) this
select concat(split_part(address_internal,'/',3),'_',split_part(address_internal,'/',4)) host_name, subtype, count(subtype) from agm.components where type = 'service' group by host_name, subtype order by host_name asc
which could give us a table chart like
which gives immediate insight into service load on each GIS service in one table - we could extend this to have soc counts next to each service type etc.
Thanks!
