https://community.splunk.com/t5/Splunk-Search/How-to-add-host-to-command-in-the-BY-section/m-p/631958#M219502 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/249492">@AShwin1119</a>,</P><P>did you explored the values option in stats command?</P><LI-CODE lang="markup">| stats values(Date_Policy) AS Date_Policy values(host) AS host BY Volume WeekRange</LI-CODE><P>Ciao.</P><P>Giuseppe</P> Thu, 23 Feb 2023 07:27:36 GMT gcusello 2023-02-23T07:27:36Z https://community.splunk.com/t5/Splunk-Search/How-to-add-host-to-command-in-the-BY-section/m-p/631949#M219500 <P>| chart values(Date_Policy) BY Volume,WeekRange,</P> <P><BR />in above command I wanted to add host as well in the BY section but not getting result for it. Can any help to fix this.</P> <P><BR />| chart values(Date_Policy) BY Volume,WeekRange, host</P> Thu, 23 Feb 2023 18:06:13 GMT https://community.splunk.com/t5/Splunk-Search/How-to-add-host-to-command-in-the-BY-section/m-p/631949#M219500 AShwin1119 2023-02-23T18:06:13Z https://community.splunk.com/t5/Splunk-Search/How-to-add-host-to-command-in-the-BY-section/m-p/631958#M219502 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/249492">@AShwin1119</a>,</P><P>did you explored the values option in stats command?</P><LI-CODE lang="markup">| stats values(Date_Policy) AS Date_Policy values(host) AS host BY Volume WeekRange</LI-CODE><P>Ciao.</P><P>Giuseppe</P> Thu, 23 Feb 2023 07:27:36 GMT https://community.splunk.com/t5/Splunk-Search/How-to-add-host-to-command-in-the-BY-section/m-p/631958#M219502 gcusello 2023-02-23T07:27:36Z