Bucket analysis

[Anonymous]

I want do the bucketing analysis of  30 days ,60 days.90 days ,90+days  ans total due

i create the bucket

Bucket Name	Min	Max
0 To 1 Months	0	30
0 To 2 Months	0	60
0 To 3 Months	0	90
3 To 6 Months	91	180
6 To 9 Months	181	270
9 To 12 Months	271	360
>12 Months	361	1000

and use 0 to 1 for 30 days and 0 to 2 for 60 days ,0 to 3 for 90 days  and 3 To 6 Months','6 To 9 Months','9 To 12 Months','>12 Months

used  for 90+ days and total  due is sum  of 30 days ,60 days.90 days ,90+days

I just want to confirm is it correct or not

[Anil_Babu_Samineni]

The way is In memory showing correct.

But, For validation you could check this in Filters only? Will you

[effinty2112]

Hi Shweta,

                    If days = 15 what bucket would you pick? It satisfies the conditions for three buckets.

Cheers

Andrew

[Anonymous]

correct so what should I use

[effinty2112]

Hi Shweta,

Try this expression to create the buckets:

Pick(

Match(-1,

Days <= 30,

Days <= 60,

Days <= 90,

Days <= 180,

Days <= 270,

Days <= 360,

-1),

'To 1 Month',

'To 2 Months',

'To 3 Months',

'To 6 Months',

'To 9 Months',

'To 12 Months',

'>12 Months')

Regards

Andrew

[sunny_talwar]

You want to do this in the script?

[Anonymous]

in front end

[Anonymous]

right now I am using this bucket of due in 30 days

Bucket Name	Min	Max
0 To 1 Months	0	30
1 To 2 Months	31	60
2 To 3 Months	61	90
3 To 6 Months	91	180
6 To 9 Months	181	270
9 To 12 Months	271	360
>12 Months	361	1000

or using this exp in order to represent 0 to 3 month

=if((WildMatch([Bucket Name],'0 To 1 Months' ,'1 To 2 Months','2 To 3 Months')),'0 To 3 Months',[Bucket Name])

[rohitraut]

Hello Shweta,

Try this,

if(Days >= 0 and Days <= 30,'To 1 Month',

     if(Days <= 60,'To 2 Months',

          if(Days <= 90,'To 3 Months',

               if(Days <= 180,'To 6 Months',

                    if(Days <= 270,'To 9 Months',

                         if(Days <= 365,'To 12 Months',

                              if(Days > 365,'GRETER THAN 12 Months')))))))