https://community.splunk.com/t5/Dashboards-Visualizations/How-to-count-or-assign-the-number-of-event/m-p/550098#M37966 <P>Ok thanks so much for this... I didn't know about streamstats is that the command for whenever we wanna know the nth position solely? I thought we only had stats thank you so much</P> Sat, 01 May 2021 02:39:56 GMT andres91302 2021-05-01T02:39:56Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-count-or-assign-the-number-of-event/m-p/550034#M37957 <P>I have a dataset that shows the logins by date and unique_session_code for each user that visits the webpage of a bakery. I am trying to come a code that allows me to&nbsp; determine if this is the first, second, third and so on... visit of this customer in other words the "nth_visit"</P><TABLE width="247"><TBODY><TR><TD width="80">USER</TD><TD width="87">LOG_DATE</TD><TD width="80">TX_REV</TD></TR><TR><TD>ALEX</TD><TD>30/04/2021</TD><TD>uyjd</TD></TR><TR><TD>MARY</TD><TD>30/04/2021</TD><TD>dn89</TD></TR><TR><TD>DOLLY</TD><TD>30/04/2021</TD><TD>nqmd0</TD></TR><TR><TD>FRANK</TD><TD>29/04/2021</TD><TD>nsj456</TD></TR><TR><TD>MARY</TD><TD>29/04/2021</TD><TD>zlpa2</TD></TR><TR><TD>DOLLY</TD><TD>29/04/2021</TD><TD>s09dm</TD></TR><TR><TD>ALEX</TD><TD>28/04/2021</TD><TD>jds02</TD></TR><TR><TD>MARY</TD><TD>28/04/2021</TD><TD>kqos98</TD></TR><TR><TD>DOLLY</TD><TD>28/04/2021</TD><TD>uiskk0</TD></TR></TBODY></TABLE><P><BR />|This would be my desired result:</P><TABLE border="0" width="320" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="80" height="20">USER</TD><TD width="80">LOG_DATE</TD><TD width="80">TX_REV</TD><TD width="80">nth_visit</TD></TR><TR><TD height="20">ALEX</TD><TD>44314</TD><TD>jds02</TD><TD>1</TD></TR><TR><TD height="20">ALEX</TD><TD>44316</TD><TD>uyjd</TD><TD>2</TD></TR><TR><TD height="20">DOLLY</TD><TD>44314</TD><TD>uiskk0</TD><TD>1</TD></TR><TR><TD height="20">DOLLY</TD><TD>44315</TD><TD>s09dm</TD><TD>2</TD></TR><TR><TD height="20">DOLLY</TD><TD>44316</TD><TD>nqmd0</TD><TD>3</TD></TR><TR><TD height="20">FRANK</TD><TD>44315</TD><TD>nsj456</TD><TD>1</TD></TR><TR><TD height="20">MARY</TD><TD>44314</TD><TD>kqos98</TD><TD>1</TD></TR><TR><TD height="20">MARY</TD><TD>44315</TD><TD>zlpa2</TD><TD>2</TD></TR><TR><TD height="20">MARY</TD><TD>44316</TD><TD>dn89</TD><TD>3</TD></TR></TBODY></TABLE><P>A&nbsp; table has the "nth_visit" to the website by each attempt of the visitor</P><P><BR />Thank you so much guys</P><P>&nbsp;</P><P>&nbsp;</P> Sun, 02 May 2021 19:58:06 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-count-or-assign-the-number-of-event/m-p/550034#M37957 andres91302 2021-05-02T19:58:06Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-count-or-assign-the-number-of-event/m-p/550038#M37959 <LI-CODE lang="markup">| streamstats count as nth_visit by USER</LI-CODE> Fri, 30 Apr 2021 16:38:01 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-count-or-assign-the-number-of-event/m-p/550038#M37959 ITWhisperer 2021-04-30T16:38:01Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-count-or-assign-the-number-of-event/m-p/550098#M37966 <P>Ok thanks so much for this... I didn't know about streamstats is that the command for whenever we wanna know the nth position solely? I thought we only had stats thank you so much</P> Sat, 01 May 2021 02:39:56 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-count-or-assign-the-number-of-event/m-p/550098#M37966 andres91302 2021-05-01T02:39:56Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-count-or-assign-the-number-of-event/m-p/550100#M37967 <P>streamstats can be used for more than just finding the nth position.</P> Sat, 01 May 2021 08:02:35 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-count-or-assign-the-number-of-event/m-p/550100#M37967 ITWhisperer 2021-05-01T08:02:35Z