https://community.splunk.com/t5/Splunk-Search/Looking-for-date-wise-Incidents-resolved-count-by-each-user/m-p/573082#M199745 <P>Use timechart with span of one day by user to get a timeseries. Then transpose the results. Finally you can do addtotals.</P> Sun, 31 Oct 2021 08:28:29 GMT PickleRick 2021-10-31T08:28:29Z https://community.splunk.com/t5/Splunk-Search/Looking-for-date-wise-Incidents-resolved-count-by-each-user/m-p/573075#M199743 <P>i am trying to pull incidents resolved by each user in date wise . can any one help me how to form the below table with count</P><TABLE width="403"><TBODY><TR><TD width="147">User Name</TD><TD width="64">10/4/2021</TD><TD width="64">10/5/2021</TD><TD width="64">10/6/2021</TD><TD width="64">Grand Total</TD></TR><TR><TD>AAAA</TD><TD>&nbsp;</TD><TD>3</TD><TD>&nbsp;</TD><TD>3</TD></TR><TR><TD>BBBBB</TD><TD>2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD></TR><TR><TD>CCCCC</TD><TD>3</TD><TD>1</TD><TD>&nbsp;</TD><TD>4</TD></TR><TR><TD>DDD</TD><TD>1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD></TR></TBODY></TABLE> Sun, 31 Oct 2021 03:31:04 GMT https://community.splunk.com/t5/Splunk-Search/Looking-for-date-wise-Incidents-resolved-count-by-each-user/m-p/573075#M199743 Gousa 2021-10-31T03:31:04Z https://community.splunk.com/t5/Splunk-Search/Looking-for-date-wise-Incidents-resolved-count-by-each-user/m-p/573082#M199745 <P>Use timechart with span of one day by user to get a timeseries. Then transpose the results. Finally you can do addtotals.</P> Sun, 31 Oct 2021 08:28:29 GMT https://community.splunk.com/t5/Splunk-Search/Looking-for-date-wise-Incidents-resolved-count-by-each-user/m-p/573082#M199745 PickleRick 2021-10-31T08:28:29Z