Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can i use same age bucket for different dashborad...with different day limits..??if so means how??????
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 ?
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.
hi,i have to like this for one dash boards..for other,3-7 like dt.
Hi,
Create 2 bucket in script .
You can not use same bucket because both bucket definition is different.
Regards,
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..
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.
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
yeah dt fields are same