Bucketing and calculating

[dseelam]

Hello Developers,

Hear is a interesting question I have count of ID for an interval bucket dimension which depends on num(dates ) in the script

In 30 day bucket I need the count of ID's in 30 days but not having the same ID in 60, 90 and 120

for example If have ID 12 in 30 day bucket it should not be counted in any other bucket 60, 90 and 120 buckets

same for 60 90 and 120

Thanks in advance

[saurabh5]

u can write a if condition:

if(isnull(date 1), null(),floor(date 1)-floor(date 2) as num_date,

then give a range:

if (isnull(num_date),null(), if (num_date<30,'0-30 days', if(num_date<61,'31-60 days',if (num_date<91,'61-90 days','91-120days'))))

try this if it works!!!

[SergeyMak]

You can use e() function, but it depends on your data model.

If you share a sample I cat try to help you with the correct expression