Age Bucket

[Nirpanthan]

Hi all,

I want to create an age bucket based on ,  open ticket  with  last  reloadedtime()

considering date as last reloaded time and ticket created time.

thanks in advance

<bar chart:
open tickets by age bucket
(< 1 day, 1 day, 2 days, 3 days, 4 days,
5 days, 6 days, 1 week +>

[Dalton_Ruer · Accepted solution]

You can simply subtract 1 date field from another. 

ReloadField - TicketOpenedField

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. 

But if you only want to know in terms of sheer calendar dates then you will want to use the FLOOR function. 

Floor(ReloadField) - Floor(TicketOpenedField)

Then you can either use the CLASS function to auto bucket or simply use a series of nested IF conditions.