How to create greater than 30,45,90 and so on days in backend..

[kavita25]

Hello everyone,

I want to show as a bucket field for greater than 30, 45 90 days and so on.

Please help me with this issue..

stalwar1‌ : Kindly look into this issue.

Regards,

Kavita

[shraddha_g]

When you are creating buckets for greater than 30,45 and 90 days,

data which exist in 'greater than 40' bucket will also be present in 'greater than 30' bucket.

Ideally it will give wrong picture.

Is there any other criteria to consider while creating buckets?

[kavita25]

Hi Shraddha,

Yeah I know that while creating buckets for greater than 30 or greater than 40 and so on will have the data present.

Also technically it will take the first condition, so that's my problem.

My requirement is if it is >30 it should give you from 31st day till the last day.

and for > 45 it should give you from 46th day till last day.

Hope you understand it.

Regards,

Kavita

[sunny_talwar]

May be like this

Fact

LOAD ....

FROM ....;

LinkTable:

LOAD Date,

     '> 30 Days' as Bucket

Resident Fact

Where Today() - Date > 30;

Concatenate (LinkTable)

LOAD Date,

     '>45 Days' as Bucket

Resident Fact

Where Today() - Date > 45;

...

and so on....