topic How to create Multi-line linechart? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-create-Multi-line-linechart/m-p/653407#M225800 <P>Guys, I have a very simple output that looks like:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD height="25px">week</TD> <TD height="25px">car</TD> <TD height="25px">total</TD> <TD height="25px">broken</TD> </TR> <TR> <TD width="25%" height="25px">31</TD> <TD width="25%" height="25px">Volvo</TD> <TD width="25%" height="25px">100</TD> <TD width="25%" height="25px">20</TD> </TR> <TR> <TD width="25%" height="25px">31</TD> <TD width="25%" height="25px">Hyundai</TD> <TD width="25%" height="25px">130</TD> <TD width="25%" height="25px">10</TD> </TR> <TR> <TD width="25%" height="25px">31</TD> <TD width="25%" height="25px">Ford</TD> <TD width="25%" height="25px">240</TD> <TD width="25%" height="25px">44</TD> </TR> <TR> <TD width="25%" height="25px">32</TD> <TD width="25%" height="25px">Volvo</TD> <TD width="25%" height="25px">98</TD> <TD width="25%" height="25px">15</TD> </TR> <TR> <TD width="25%" height="25px">32</TD> <TD width="25%" height="25px">Hyundai</TD> <TD width="25%" height="25px">143</TD> <TD width="25%" height="25px">7</TD> </TR> <TR> <TD width="25%" height="25px">32</TD> <TD width="25%" height="25px">Ford</TD> <TD width="25%" height="25px">238</TD> <TD width="25%" height="25px">52</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>What I need is a linechart where X-axis is week number and there are 2 lines per product - total and broken.</P> <P>This works for one, but not sure how to include the other:</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">query | chart values(broken) by week, car</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 07 Aug 2023 19:25:14 GMT fishmong3r0 2023-08-07T19:25:14Z How to create Multi-line linechart? https://community.splunk.com/t5/Splunk-Search/How-to-create-Multi-line-linechart/m-p/653407#M225800 <P>Guys, I have a very simple output that looks like:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD height="25px">week</TD> <TD height="25px">car</TD> <TD height="25px">total</TD> <TD height="25px">broken</TD> </TR> <TR> <TD width="25%" height="25px">31</TD> <TD width="25%" height="25px">Volvo</TD> <TD width="25%" height="25px">100</TD> <TD width="25%" height="25px">20</TD> </TR> <TR> <TD width="25%" height="25px">31</TD> <TD width="25%" height="25px">Hyundai</TD> <TD width="25%" height="25px">130</TD> <TD width="25%" height="25px">10</TD> </TR> <TR> <TD width="25%" height="25px">31</TD> <TD width="25%" height="25px">Ford</TD> <TD width="25%" height="25px">240</TD> <TD width="25%" height="25px">44</TD> </TR> <TR> <TD width="25%" height="25px">32</TD> <TD width="25%" height="25px">Volvo</TD> <TD width="25%" height="25px">98</TD> <TD width="25%" height="25px">15</TD> </TR> <TR> <TD width="25%" height="25px">32</TD> <TD width="25%" height="25px">Hyundai</TD> <TD width="25%" height="25px">143</TD> <TD width="25%" height="25px">7</TD> </TR> <TR> <TD width="25%" height="25px">32</TD> <TD width="25%" height="25px">Ford</TD> <TD width="25%" height="25px">238</TD> <TD width="25%" height="25px">52</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>What I need is a linechart where X-axis is week number and there are 2 lines per product - total and broken.</P> <P>This works for one, but not sure how to include the other:</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">query | chart values(broken) by week, car</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 07 Aug 2023 19:25:14 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-Multi-line-linechart/m-p/653407#M225800 fishmong3r0 2023-08-07T19:25:14Z Re: Multi-line linechart https://community.splunk.com/t5/Splunk-Search/How-to-create-Multi-line-linechart/m-p/653411#M225804 <LI-CODE lang="markup">| chart values(total) as total values(broken) as broken by week car</LI-CODE> Mon, 07 Aug 2023 13:26:08 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-Multi-line-linechart/m-p/653411#M225804 ITWhisperer 2023-08-07T13:26:08Z