https://community.splunk.com/t5/Splunk-Search/how-to-create-a-table-with-empty-cells/m-p/485591#M135865 <P>Hello,<BR /> I would like to create a table in below format in splunk.</P> <P>should display first value in first cell of first column, 2nd value in 2nd cell of 2nd column, 3rd value in 3rd cell of 3rd column.<BR /> <span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/8229i28B4656AF434074A/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>can someone help me if it is possible ?</P> <P>Thanks in Advance<BR /> Praveen</P> Tue, 21 Jan 2020 06:06:43 GMT PC00128849 2020-01-21T06:06:43Z https://community.splunk.com/t5/Splunk-Search/how-to-create-a-table-with-empty-cells/m-p/485591#M135865 <P>Hello,<BR /> I would like to create a table in below format in splunk.</P> <P>should display first value in first cell of first column, 2nd value in 2nd cell of 2nd column, 3rd value in 3rd cell of 3rd column.<BR /> <span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/8229i28B4656AF434074A/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>can someone help me if it is possible ?</P> <P>Thanks in Advance<BR /> Praveen</P> Tue, 21 Jan 2020 06:06:43 GMT https://community.splunk.com/t5/Splunk-Search/how-to-create-a-table-with-empty-cells/m-p/485591#M135865 PC00128849 2020-01-21T06:06:43Z https://community.splunk.com/t5/Splunk-Search/how-to-create-a-table-with-empty-cells/m-p/485592#M135866 <P>@PC00128849 ,<BR /> Whats the input ? Are these fields from single event? </P> Tue, 21 Jan 2020 06:47:11 GMT https://community.splunk.com/t5/Splunk-Search/how-to-create-a-table-with-empty-cells/m-p/485592#M135866 renjith_nair 2020-01-21T06:47:11Z https://community.splunk.com/t5/Splunk-Search/how-to-create-a-table-with-empty-cells/m-p/485593#M135867 <P>no, not from single event. There are thousands of events.<BR /> i will do some calculations and get those numbers.<BR /> but my problem is to place the results/numbers in a particular cell [A2 &amp; B3 and so on] in each columns/rows.</P> Tue, 21 Jan 2020 06:54:31 GMT https://community.splunk.com/t5/Splunk-Search/how-to-create-a-table-with-empty-cells/m-p/485593#M135867 PC00128849 2020-01-21T06:54:31Z https://community.splunk.com/t5/Splunk-Search/how-to-create-a-table-with-empty-cells/m-p/485594#M135868 <P>Hi @PC00128849,<BR /> try if this is what you want:</P> <PRE><CODE>index=wineventlog | stats count BY EventCode | xyseries EventCode EventCode count | fields - EventCode </CODE></PRE> <P>Ciao.<BR /> Giuseppe</P> Tue, 21 Jan 2020 08:03:56 GMT https://community.splunk.com/t5/Splunk-Search/how-to-create-a-table-with-empty-cells/m-p/485594#M135868 gcusello 2020-01-21T08:03:56Z