Script

[Anonymous]

Hi,

can i use same age bucket for different dashborad...with different day limits..??if so means how??????

[varshavig12]

Okay not so clear,

Example:

You have a bucket for age-group, 0-15 as small, 16-35 as adult and rest as old.

Now you want to use the above same bucket for two different charts , with one having limits like 0-2 days , 3-5 days and other as 0-2 days , 3-7 and so on ?

[Anonymous]

Thnks for ur post krish,bt i have alrdy created the age bucket.bt the problem is limitation.one dashboards need some limitation and other dashboards needs some limitation..bt by using same age data.

[Anonymous]

hi,i have to like this for one dash boards..for other,3-7 like dt.

[PrashantSangle]

Hi,

Create 2 bucket in script .

You can not use same bucket because both bucket definition is different.

Regards,

[Anonymous]

hi max,

i tried dt one too.if i do ths means,

ZFIFO_Ageing:

LOAD * inline [

ZFStart,ZFEnd,ZFBucket

0,2,0-2 Days

3,5,3-5 Days

6,7,6-7 days

8,15,8-15 Days

16,30,16-30 Days

30,999999,>30 days

8,999999,>7 days

];

IntervalMatch(ZF_Age)

Load ZFStart,

     ZFEnd

Resident ZFIFO_Ageing;

ZFIFO_Ageing1:

LOAD * inline [

ZFStarts,ZFEnds,ZFBuckets

0,2,0-2 Days

3,7,3-7 Days

8,15,8-15 Days

16,30,16-30 Days

30,999999,>30 days

8,999999,>7 days

];

IntervalMatch(ZF_Age)

Load ZFStarts,

     ZFEnds

Resident ZFIFO_Ageings;

It does not show 0-2 days limit..bcoz it appear in both script...bt i need..

[Anonymous]

In both interval match functions you used the same filed (ZF_Age),check in this filed,

based on this filed only data is going to reflect.

and

in second statement your have to resident from ZFIFO_Ageing1,

but your resident from ZFIFO_Ageings;

verify this.

Thanq.

[PrashantSangle · Accepted solution]

Hi,

are you sure your data is like is this????

You can try like this

ZFIFO_Ageing:

LOAD * inline [

ZFStart,ZFEnd,ZFBucket

0,2,0-2 Days

3,5,3-5 Days

6,7,6-7 days

8,15,8-15 Days

16,30,16-30 Days

30,999999,>30 days

8,999999,>7 days

];

concatenate

//ZFIFO_Ageing1:

LOAD ZFStarts as ZFStart, ZFEnds as ZFEnd, ZFBuckets as ZFBucket inline [

ZFStarts,ZFEnds,ZFBuckets

0,2,0-2 Days

3,7,3-7 Days

8,15,8-15 Days

16,30,16-30 Days

30,999999,>30 days

8,999999,>7 days

];

IntervalMatch(ZF_Age)

Load ZFStart,

     ZFEnd

Resident ZFIFO_Ageing;

Regards

[Anonymous]

yeah dt fields are same