https://community.qlik.com/t5/App-Development/Age-Bucket/m-p/1799378#M64748 <P>Hi all,</P><P>I want to create an age bucket based on ,&nbsp; open ticket&nbsp; with&nbsp; last&nbsp; reloadedtime()</P><P>considering date as last reloaded time and ticket created time.</P><P>thanks in advance</P><DIV><DIV><DIV><DIV class="cell-input disabled-input">&lt;bar chart:<BR />open tickets by age bucket<BR />(&lt; 1 day, 1 day, 2 days, 3 days, 4 days,<BR />5 days, 6 days, 1 week +&gt;</DIV><P>&nbsp;</P></DIV></DIV></DIV> Wed, 14 Apr 2021 11:33:14 GMT Nirpanthan 2021-04-14T11:33:14Z https://community.qlik.com/t5/App-Development/Age-Bucket/m-p/1799378#M64748 <P>Hi all,</P><P>I want to create an age bucket based on ,&nbsp; open ticket&nbsp; with&nbsp; last&nbsp; reloadedtime()</P><P>considering date as last reloaded time and ticket created time.</P><P>thanks in advance</P><DIV><DIV><DIV><DIV class="cell-input disabled-input">&lt;bar chart:<BR />open tickets by age bucket<BR />(&lt; 1 day, 1 day, 2 days, 3 days, 4 days,<BR />5 days, 6 days, 1 week +&gt;</DIV><P>&nbsp;</P></DIV></DIV></DIV> Wed, 14 Apr 2021 11:33:14 GMT https://community.qlik.com/t5/App-Development/Age-Bucket/m-p/1799378#M64748 Nirpanthan 2021-04-14T11:33:14Z https://community.qlik.com/t5/App-Development/Age-Bucket/m-p/1799460#M64762 <P>You can simply subtract 1 date field from another.&nbsp;</P><P>ReloadField - TicketOpenedField</P><P>Since both are likely timestamp values you will have decimals involved. Which may be a good thing if you want to know that something may be a few hours after 1 whole day.&nbsp;</P><P>But if you only want to know in terms of sheer calendar dates then you will want to use the FLOOR function.&nbsp;</P><P>Floor(ReloadField) - Floor(TicketOpenedField)</P><P>Then you can either use the CLASS function to auto bucket or simply use a series of nested IF conditions.&nbsp;</P> Wed, 14 Apr 2021 14:08:47 GMT https://community.qlik.com/t5/App-Development/Age-Bucket/m-p/1799460#M64762 Dalton_Ruer 2021-04-14T14:08:47Z