sas viya3.5 va 8.5.1 - Custom Category

[vallsas]

Hi,

I am creating a custom category from a category data item as I would like to do different groups.

Actul_column

AAA

BBB

CCC

DDD

EEE

FFF

Cutom_cat_colum

group1 : AAA

              BBB

              CCC

group2 :AAA

             EEE

Group3: DDD

              FFF

Group4:AAA

             BBB

             CCC

             DDD

             EEE

             FFF

The problem is once I select the value into one group and then i have option to select the same value into another group.

what is the alternative solution ?

[MarkusWeick]

Hi @vallsas,

what do you want to do with the groups?

Maybe it's feasible to have one calculated item per group?

Best

Markus

[vallsas]

This is actual group of records and need to calculate the records and their percentage as per the business requirement.

I gave sample data which is same pattern of real data.

as adding more info

Grouping each dept and all the dept group count and their performance percentage i would like to calculate.

if i use button bar in a report

I can see group1 group2 group3 group4 so i get the count by each and finally all the group count on the same button bar based on the selection different charts show the statistics further on the same report.

let me know still need more explanation.

thanks

[MarkusWeick]

So lets see, if I have understood it.

In the terms of your first example:

You want to have group 1 to group 4 and total as choices on the button bar.

If group 1 is choosen, you want a calculation on AAA, BBB and CCC,

if group 4 is choosen you want a calculation on AAA, BBB, CCC, DDD, EEE and FFF.

Right?

[vallsas]

Yes, you are right!

[MarkusWeick]

I recommend buidling a calcuated item for each group, which holds either the group member or a "missing".

[MarkusWeick]

Have you tried it:

In your example's terms:

[vallsas]

No,
I did not understand the code and result how it looks.

[MarkusWeick]

If you uploaded an extract of your data, maybe I could give you a more specific example.

[vallsas]

Hi, Bruehl
pls find attached file thanks

[MarkusWeick]

Hi, @vallsas ,

I can't see attachment.

Best

Markus

[vallsas]

INCIDENT_NUMBER	DEP_NAME	SLA	date	measure
ABC1234		AAA	SLA	20-Dec-21	REQ
BDC1223		AAA	SLA	21-Dec-21	INC
ABC2345		BBB	NOSLA	26-Dec-21	REQ
BBC5678		BBB	NOSLA	23-Dec-21	INC
NNC3456		CCC	SLA	29-Dec-21	REQ
MMM2345		CCC	NOSLA	30-Dec-21	INC
YOU9876		CCC	SLA	1-Jan-22	REQ
UUU2345		AAA	NOSLA	2-Jan-22	INC
III9999		AAA	SLA	3-Jan-22	REQ
YYYY5678	BBB	SLA	4-Jan-22	INC
EEE4567		BBB	SLA	1-Feb-22	REQ
WWW2345		CCC	SLA	2-Feb-22	INC
RRR3456		AAA	SLA	3-Feb-22	REQ
EEE2345		AAA	SLA	4-Feb-22	INC 

unable to attach the file but can you please paste the above info in excel and import.

thanks

This video is currently being processed. Please try again in a few minutes.

 

[MarkusWeick]

Hi @vallsas.,

I defined group 1  as containing teh deaprtments AAA and BBB. Is the following what you want to see if you choose group 1:

?

[vallsas]

Hi @MarkusWeick 

here I want to see group4 all the above three groups items in one group. pls see the below screen shot why i am asking like that.

if we click on all then we get the sat for all the groups.

let me know is it clear to you.

thanks

[MarkusWeick]

Hi @vallsas,

originally I understood, that you wanted to have AAA, BBB, CCC all in Groupq and Group 1 on the button bar.

Is this still true?