https://community.splunk.com/t5/Getting-Data-In/How-to-display-fields-in-a-table-panel-even-if-the-result-field/m-p/462968#M79911 <P>@jip31</P> <P>Can you please try this?</P> <PRE><CODE> `windows` sourcetype="Win" OR sourcetype=report OR sourcetype=abdm OR sourcetype=app OR sourcetype="flags" OR sourcetype="up" | stats dc(host) as count by sourcetype | sort -"Number of hosts" | append [| makeresults | eval sourcetype="Win||report||abdm||app||flags||up",sourcetype=split(sourcetype,"||"), count=0 | mvexpand sourcetype | table sourcetype count ] | stats sum(count) as "Number of hosts" by sourcetype </CODE></PRE> Fri, 18 Oct 2019 08:08:35 GMT kamlesh_vaghela 2019-10-18T08:08:35Z https://community.splunk.com/t5/Getting-Data-In/How-to-display-fields-in-a-table-panel-even-if-the-result-field/m-p/462967#M79910 <P>hello</P> <P>In a panel table, I need to display every sourcetype results even if the sourcetype result = 0<BR /> I have done an if condition but it doenst works<BR /> could you help me please?</P> <PRE><CODE>`windows` sourcetype="Win" OR sourcetype=report OR sourcetype=abdm OR sourcetype=app OR sourcetype="flags" OR sourcetype="up" | stats dc(host) as "Number of hosts" by sourcetype | sort -"Number of hosts" </CODE></PRE> Fri, 18 Oct 2019 07:28:47 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-display-fields-in-a-table-panel-even-if-the-result-field/m-p/462967#M79910 jip31 2019-10-18T07:28:47Z https://community.splunk.com/t5/Getting-Data-In/How-to-display-fields-in-a-table-panel-even-if-the-result-field/m-p/462968#M79911 <P>@jip31</P> <P>Can you please try this?</P> <PRE><CODE> `windows` sourcetype="Win" OR sourcetype=report OR sourcetype=abdm OR sourcetype=app OR sourcetype="flags" OR sourcetype="up" | stats dc(host) as count by sourcetype | sort -"Number of hosts" | append [| makeresults | eval sourcetype="Win||report||abdm||app||flags||up",sourcetype=split(sourcetype,"||"), count=0 | mvexpand sourcetype | table sourcetype count ] | stats sum(count) as "Number of hosts" by sourcetype </CODE></PRE> Fri, 18 Oct 2019 08:08:35 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-display-fields-in-a-table-panel-even-if-the-result-field/m-p/462968#M79911 kamlesh_vaghela 2019-10-18T08:08:35Z https://community.splunk.com/t5/Getting-Data-In/How-to-display-fields-in-a-table-panel-even-if-the-result-field/m-p/462969#M79912 <P>many thanks!!</P> Fri, 18 Oct 2019 10:43:07 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-display-fields-in-a-table-panel-even-if-the-result-field/m-p/462969#M79912 jip31 2019-10-18T10:43:07Z