<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>idea Include a table chart for analysis in ArcGIS Monitor Ideas</title>
    <link>https://community.esri.com/t5/arcgis-monitor-ideas/include-a-table-chart-for-analysis/idi-p/1394927</link>
    <description>&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;With the&amp;nbsp;Number of ArcGIS Server Services by Type example at&amp;nbsp;&lt;A href="https://www.esri.com/arcgis-blog/products/monitor/administration/5-useful-arcgis-server-analysis-elements-in-arcgis-monitor/" target="_blank"&gt;https://www.esri.com/arcgis-blog/products/monitor/administration/5-useful-arcgis-server-analysis-elements-in-arcgis-monitor/&lt;/A&gt;&amp;nbsp;- it does this in a graphical form but you have to highlight over the donut section to get the count&amp;nbsp; - and would have to include the server name in the title or the like. You'd need multiple charts for multiple servers -&amp;nbsp; but being able to have a table would also be useful for some items.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="FraserHand_0-1710277140869.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/97778i0D969D57C2ECB113/image-size/medium?v=v2&amp;amp;px=400" role="button" title="FraserHand_0-1710277140869.png" alt="FraserHand_0-1710277140869.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;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&amp;nbsp;&lt;/P&gt;&lt;P&gt;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&lt;/P&gt;&lt;P&gt;which could give us a table chart like&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="FraserHand_1-1710278584608.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/97779iDA4C449D2F89128C/image-size/medium?v=v2&amp;amp;px=400" role="button" title="FraserHand_1-1710278584608.png" alt="FraserHand_1-1710278584608.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 12 Mar 2024 21:26:23 GMT</pubDate>
    <dc:creator>FraserHand</dc:creator>
    <dc:date>2024-03-12T21:26:23Z</dc:date>
    <item>
      <title>Include a table chart for analysis</title>
      <link>https://community.esri.com/t5/arcgis-monitor-ideas/include-a-table-chart-for-analysis/idi-p/1394927</link>
      <description>&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;With the&amp;nbsp;Number of ArcGIS Server Services by Type example at&amp;nbsp;&lt;A href="https://www.esri.com/arcgis-blog/products/monitor/administration/5-useful-arcgis-server-analysis-elements-in-arcgis-monitor/" target="_blank"&gt;https://www.esri.com/arcgis-blog/products/monitor/administration/5-useful-arcgis-server-analysis-elements-in-arcgis-monitor/&lt;/A&gt;&amp;nbsp;- it does this in a graphical form but you have to highlight over the donut section to get the count&amp;nbsp; - and would have to include the server name in the title or the like. You'd need multiple charts for multiple servers -&amp;nbsp; but being able to have a table would also be useful for some items.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="FraserHand_0-1710277140869.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/97778i0D969D57C2ECB113/image-size/medium?v=v2&amp;amp;px=400" role="button" title="FraserHand_0-1710277140869.png" alt="FraserHand_0-1710277140869.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;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&amp;nbsp;&lt;/P&gt;&lt;P&gt;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&lt;/P&gt;&lt;P&gt;which could give us a table chart like&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="FraserHand_1-1710278584608.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/97779iDA4C449D2F89128C/image-size/medium?v=v2&amp;amp;px=400" role="button" title="FraserHand_1-1710278584608.png" alt="FraserHand_1-1710278584608.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 12 Mar 2024 21:26:23 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-monitor-ideas/include-a-table-chart-for-analysis/idi-p/1394927</guid>
      <dc:creator>FraserHand</dc:creator>
      <dc:date>2024-03-12T21:26:23Z</dc:date>
    </item>
    <item>
      <title>Re: Include a table chart for analysis - Status changed to: Under Consideration</title>
      <link>https://community.esri.com/t5/arcgis-monitor-ideas/include-a-table-chart-for-analysis/idc-p/1395259#M394</link>
      <description />
      <pubDate>Wed, 13 Mar 2024 14:40:42 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-monitor-ideas/include-a-table-chart-for-analysis/idc-p/1395259#M394</guid>
      <dc:creator>GeoJen</dc:creator>
      <dc:date>2024-03-13T14:40:42Z</dc:date>
    </item>
    <item>
      <title>Re: Include a table chart for analysis - Status changed to: Implemented</title>
      <link>https://community.esri.com/t5/arcgis-monitor-ideas/include-a-table-chart-for-analysis/idc-p/1575337#M518</link>
      <description>&lt;P&gt;Table element will be added at ArcGIS Monitor 2024.1.&lt;/P&gt;</description>
      <pubDate>Tue, 14 Jan 2025 15:17:23 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-monitor-ideas/include-a-table-chart-for-analysis/idc-p/1575337#M518</guid>
      <dc:creator>GeoJosh</dc:creator>
      <dc:date>2025-01-14T15:17:23Z</dc:date>
    </item>
  </channel>
</rss>

