https://community.splunk.com/t5/Splunk-Search/How-do-I-extract-value-from-stats-list/m-p/557063#M158202 <P>I want to extract count from list (picture 1 ) to table (picture 2) How do&nbsp; I&nbsp; do?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup"> |stats count by Name,severity |sort - count | stats list(severity) as severity, list(count) as count, sum(count) as Total by Name | sort -Total</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>The field severity is follow by name the count for each level inside severity</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="apichai32356_0-1624565098885.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/14803i6B17D6487A4132B3/image-size/medium?v=v2&amp;px=400" role="button" title="apichai32356_0-1624565098885.png" alt="apichai32356_0-1624565098885.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="apichai32356_1-1624565112484.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/14804iB216CE92CAB58D3B/image-size/medium?v=v2&amp;px=400" role="button" title="apichai32356_1-1624565112484.png" alt="apichai32356_1-1624565112484.png" /></span></P><P>&nbsp;</P> Thu, 24 Jun 2021 20:13:05 GMT apichai32356 2021-06-24T20:13:05Z https://community.splunk.com/t5/Splunk-Search/How-do-I-extract-value-from-stats-list/m-p/557063#M158202 <P>I want to extract count from list (picture 1 ) to table (picture 2) How do&nbsp; I&nbsp; do?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup"> |stats count by Name,severity |sort - count | stats list(severity) as severity, list(count) as count, sum(count) as Total by Name | sort -Total</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>The field severity is follow by name the count for each level inside severity</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="apichai32356_0-1624565098885.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/14803i6B17D6487A4132B3/image-size/medium?v=v2&amp;px=400" role="button" title="apichai32356_0-1624565098885.png" alt="apichai32356_0-1624565098885.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="apichai32356_1-1624565112484.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/14804iB216CE92CAB58D3B/image-size/medium?v=v2&amp;px=400" role="button" title="apichai32356_1-1624565112484.png" alt="apichai32356_1-1624565112484.png" /></span></P><P>&nbsp;</P> Thu, 24 Jun 2021 20:13:05 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-extract-value-from-stats-list/m-p/557063#M158202 apichai32356 2021-06-24T20:13:05Z https://community.splunk.com/t5/Splunk-Search/How-do-I-extract-value-from-stats-list/m-p/557066#M158203 <LI-CODE lang="markup">| chart count by Name,severity | addtotals</LI-CODE> Thu, 24 Jun 2021 20:39:09 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-extract-value-from-stats-list/m-p/557066#M158203 ITWhisperer 2021-06-24T20:39:09Z https://community.splunk.com/t5/Splunk-Search/How-do-I-extract-value-from-stats-list/m-p/557071#M158204 <P>I have try, but the information are inaccurate&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="apichai32356_0-1624567815751.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/14805iE877F2A4E700F53E/image-size/medium?v=v2&amp;px=400" role="button" title="apichai32356_0-1624567815751.png" alt="apichai32356_0-1624567815751.png" /></span></P><P>&nbsp;</P> Thu, 24 Jun 2021 20:51:17 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-extract-value-from-stats-list/m-p/557071#M158204 apichai32356 2021-06-24T20:51:17Z https://community.splunk.com/t5/Splunk-Search/How-do-I-extract-value-from-stats-list/m-p/557072#M158205 <P>Ok, now I know the error point thank you Mr.<SPAN>ITWhisperer .</SPAN></P> Thu, 24 Jun 2021 20:57:03 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-extract-value-from-stats-list/m-p/557072#M158205 apichai32356 2021-06-24T20:57:03Z https://community.splunk.com/t5/Splunk-Search/How-do-I-extract-value-from-stats-list/m-p/557073#M158206 <LI-CODE lang="markup">| stats count by Name,severity | xyseries Name severity count | addtotals</LI-CODE> Thu, 24 Jun 2021 20:57:41 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-extract-value-from-stats-list/m-p/557073#M158206 ITWhisperer 2021-06-24T20:57:41Z