https://community.qlik.com/t5/Search-the-Community/How-to-calculate-consecutive-days/m-p/1814736#M367 <P>Hi All,</P><P>I want to know the number of consecutive days bike was used.&nbsp;How many consecutive days in a row does the average bike get used?&nbsp; Below is the snippet of data. Actual data is more than 300000 rows. Please help. Thanks&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="manikwalia_0-1623624277370.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56734i225D8528CDD0BB9F/image-size/medium?v=v2&amp;px=400" role="button" title="manikwalia_0-1623624277370.png" alt="manikwalia_0-1623624277370.png" /></span></P><P>&nbsp;</P> Sun, 13 Jun 2021 22:44:59 GMT manikwalia 2021-06-13T22:44:59Z https://community.qlik.com/t5/Search-the-Community/How-to-calculate-consecutive-days/m-p/1814736#M367 <P>Hi All,</P><P>I want to know the number of consecutive days bike was used.&nbsp;How many consecutive days in a row does the average bike get used?&nbsp; Below is the snippet of data. Actual data is more than 300000 rows. Please help. Thanks&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="manikwalia_0-1623624277370.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56734i225D8528CDD0BB9F/image-size/medium?v=v2&amp;px=400" role="button" title="manikwalia_0-1623624277370.png" alt="manikwalia_0-1623624277370.png" /></span></P><P>&nbsp;</P> Sun, 13 Jun 2021 22:44:59 GMT https://community.qlik.com/t5/Search-the-Community/How-to-calculate-consecutive-days/m-p/1814736#M367 manikwalia 2021-06-13T22:44:59Z