Script

[Anonymous]

Hi,

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

[varshavig12]

Can you give us an example for the same ?

[Anonymous]

Hi sindhu,

you can create a same size of buckets by using class function.

and

you posted..can i create age buckets for different dashboards....means....plz elaborate with more details.

[Anonymous]

For one dashboard, i have to create limits like 0-2 days,3-5days like tht,

For other dashboard,i have to create limits like 0-2 days,3-7 days like dt,

if i create means its shows the all limits in same dashboard,bt i need nly specific limits for specific dashboards.

[Anonymous]

i mean to say,can i use the same age bucket for different dashboards

[Anonymous]

Can you pls share the In-progress version of the script you have so that we can give our suggestions on that?

A sample should be a good way to 

[Anonymous]

your using same data in both the dashboards?

[Anonymous]

Ofcourse kalyani, but i have to use same data only...for diff dshboard....how can i do ths.

[Anonymous]

Hi sindhu,

you can create a same size of buckets by using class function.

  Ex:

LOAD Name, DOB, Age

       Dual(Replace(Class(Age,5),'<= x <','to'), Num(Class(Aage,5))) as Bucket
FROM
[..\Desktop\Book1.xlsx]
(ooxml, embedded labels, table is Sheet1);

  you can't create a same size of buckets by using if.

Ex:

LOAD Name, DOB Age,

  If(Date(DOB)>='01/01/1945' and Date(DOB)<='12/31/1960', 'Baby Boomers',
If(Date(DOB)>='01/01/1961' and Date(DOB)<='12/31/1980', 'Gen X',
If(Date(DOB)>='01/01/1981' and Date(DOB)<='12/31/1995', 'Gen Y','Gen Z'))) as Gen

    FROM
[..\Desktop\Book1.xlsx]
(ooxml, embedded labels, table is Sheet1);

[Anonymous]

what is your exact requirement sindhu...

you shared something limits on dashboards....can you please more detail,

then i will get clarity on your ..scenario.