I have to create a bar chart where dimension one is requirement status is closed request and dimension 2 is skill on the basis of this i have to find the closed status by aging
For aging i have used this script in load editor
Load "CC_CLOSED_DATE" ,
"CC_REQUEST_CREATED_ON",
Num(Today() - "CC_REQUEST_CREATED_ON" ) as OpenAgeBucket,
Num("CC_CLOSED_DATE" - "CC_REQUEST_CREATED_ON") as ClosedAgeBucket
Resident Open;
drop Table Open;
ST:
Noconcatenate
Load OpenAgeBucket,
if(OpenAgeBucket>=0 and OpenAgeBucket<=90,'0-90 days' ,
if(OpenAgeBucket>=91 and OpenAgeBucket<=180,'91-180 days',
if(OpenAgeBucket>=181 and OpenAgeBucket<=270,'181-270days' ,
if(OpenAgeBucket>=271and OpenAgeBucket<=360,'271-360 days',
if(OpenAgeBucket>=361 and OpenAgeBucket<=2000,'361-2000 days'))))) as O_D_Age_Bucket
resident SD;
// Drop table SD ;
Noconcatenate
ST:
Load OpenAgeBucket,
if(OpenAgeBucket>=0 and OpenAgeBucket<=90,'0-3 month',
if(OpenAgeBucket>=91 and OpenAgeBucket<=180,'4-6 month',
if(OpenAgeBucket>=181 and OpenAgeBucket<=270,'7-9 month',
if(OpenAgeBucket>=271 and OpenAgeBucket<=360,'10-12 month',
if(OpenAgeBucket>=361 and OpenAgeBucket<=2000,'More Then 12 Months')))))
as O_M_Age_Bucket
resident SD;
// Drop table SD ;
after doing this i can not able to get the desire output in bar chart for closed request status by aging (role wise)
what will be the expression to get that desire output in set analysis?
