https://community.splunk.com/t5/Splunk-Search/How-to-search-and-table-count-for-multiple-fields/m-p/198553#M57412 <P>Can anyone help me making this table?<BR /> I have the field Status, wich has events Status=1, Status=2, Status=3.<BR /> I need to count events for each and make a table for each, example</P> <PRE><CODE>Channel | Total Status = 1 | Total Status = 2 | Total Status = 3 Channel A Channel B Channel C </CODE></PRE> <P>This is my current query:</P> <P><STRONG><CODE>index=main sourcetype=control | stats count, values(Status) as Status by STATUS | table Channel, count</CODE></STRONG></P> Fri, 29 Aug 2014 17:24:27 GMT vtsguerrero 2014-08-29T17:24:27Z https://community.splunk.com/t5/Splunk-Search/How-to-search-and-table-count-for-multiple-fields/m-p/198553#M57412 <P>Can anyone help me making this table?<BR /> I have the field Status, wich has events Status=1, Status=2, Status=3.<BR /> I need to count events for each and make a table for each, example</P> <PRE><CODE>Channel | Total Status = 1 | Total Status = 2 | Total Status = 3 Channel A Channel B Channel C </CODE></PRE> <P>This is my current query:</P> <P><STRONG><CODE>index=main sourcetype=control | stats count, values(Status) as Status by STATUS | table Channel, count</CODE></STRONG></P> Fri, 29 Aug 2014 17:24:27 GMT https://community.splunk.com/t5/Splunk-Search/How-to-search-and-table-count-for-multiple-fields/m-p/198553#M57412 vtsguerrero 2014-08-29T17:24:27Z https://community.splunk.com/t5/Splunk-Search/How-to-search-and-table-count-for-multiple-fields/m-p/198554#M57413 <P>I forgot to mention that this table should also show per Channel for each line :X<BR /> What's the easiest way I can do this?</P> Fri, 29 Aug 2014 18:02:33 GMT https://community.splunk.com/t5/Splunk-Search/How-to-search-and-table-count-for-multiple-fields/m-p/198554#M57413 vtsguerrero 2014-08-29T18:02:33Z https://community.splunk.com/t5/Splunk-Search/How-to-search-and-table-count-for-multiple-fields/m-p/198555#M57414 <PRE><CODE>index=main sourcetype=control | chart count over Channel by STATUS </CODE></PRE> <P>?</P> Fri, 29 Aug 2014 18:28:37 GMT https://community.splunk.com/t5/Splunk-Search/How-to-search-and-table-count-for-multiple-fields/m-p/198555#M57414 Ayn 2014-08-29T18:28:37Z https://community.splunk.com/t5/Splunk-Search/How-to-search-and-table-count-for-multiple-fields/m-p/198556#M57415 <P>Thanks a lot Ayn! Solved my problems! <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P> Fri, 29 Aug 2014 18:37:57 GMT https://community.splunk.com/t5/Splunk-Search/How-to-search-and-table-count-for-multiple-fields/m-p/198556#M57415 vtsguerrero 2014-08-29T18:37:57Z