https://community.splunk.com/t5/Splunk-Search/how-to-display-data-with-multiple-column-and-row/m-p/174131#M49949 <P>Try this</P> <PRE><CODE>yoursearchhere | stats count(eval(status="Failed")) as fail, count(eval(status="Passed")) as pass by workweek subArea | eval passPercentage=if(pass+fail== 0, "-",round(pass/(pass+fail)*100,2)) | xyseries workweek subArea passPercentage </CODE></PRE> Wed, 05 Mar 2014 05:49:52 GMT lguinn2 2014-03-05T05:49:52Z https://community.splunk.com/t5/Splunk-Search/how-to-display-data-with-multiple-column-and-row/m-p/174130#M49948 <P>I need to create a table which will display</P> <P>workweek as rows</P> <P>and subarea as column, meanwhile the data inside will display the passing percentage for each subarea for every workweek.</P> <P>i tried</P> <P>*|stats count(eval(status="Failed")) AS fail,count(eval(status="Passed")) AS pass by workweek|eval passPercentage=if(pass+fail== 0, "-",round(pass/(pass+fail)*100,2))|fields workweek,passPercentage</P> <P>This will only calculate for overall passPercentage for each workweek, but i want it to be done with each subarea of each workweek...</P> <P>my sample output will be like this</P> <PRE><CODE> subArea1 subArea2 subArea3... </CODE></PRE> <P>workweek1 12 32 88 </P> <P>workweek2 96 45 12 </P> <P>workweek3 23 78 43 </P> <P>workweek4 37 79 98</P> Mon, 28 Sep 2020 16:02:34 GMT https://community.splunk.com/t5/Splunk-Search/how-to-display-data-with-multiple-column-and-row/m-p/174130#M49948 jasklee 2020-09-28T16:02:34Z https://community.splunk.com/t5/Splunk-Search/how-to-display-data-with-multiple-column-and-row/m-p/174131#M49949 <P>Try this</P> <PRE><CODE>yoursearchhere | stats count(eval(status="Failed")) as fail, count(eval(status="Passed")) as pass by workweek subArea | eval passPercentage=if(pass+fail== 0, "-",round(pass/(pass+fail)*100,2)) | xyseries workweek subArea passPercentage </CODE></PRE> Wed, 05 Mar 2014 05:49:52 GMT https://community.splunk.com/t5/Splunk-Search/how-to-display-data-with-multiple-column-and-row/m-p/174131#M49949 lguinn2 2014-03-05T05:49:52Z