BookmarkSubscribeRSS Feed
vallsas
Pyrite | Level 9

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 ?

 

 

 

19 REPLIES 19
MarkusWeick
Barite | Level 11

Hi @vallsas,

what do you want to do with the groups?

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

 

Best

Markus

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles
vallsas
Pyrite | Level 9

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
Barite | Level 11

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?

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles
vallsas
Pyrite | Level 9
Yes, you are right!
MarkusWeick
Barite | Level 11

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

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles
MarkusWeick
Barite | Level 11

Have you tried it:

In your example's terms:

Calculated Item (2).png

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles
vallsas
Pyrite | Level 9
No,
I did not understand the code and result how it looks.
MarkusWeick
Barite | Level 11

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

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles
vallsas
Pyrite | Level 9
Hi, Bruehl
pls find attached file thanks
MarkusWeick
Barite | Level 11

Hi, @vallsas ,

I can't see attachment.

Best

Markus

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles
vallsas
Pyrite | Level 9
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.
(view in My Videos)
 

MarkusWeick
Barite | Level 11

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:

Groupings1 (2).png

?

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles
vallsas
Pyrite | Level 9

Hi @MarkusWeick 

vallsas_2-1661432161888.png

 

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.

 

vallsas_4-1661432259445.png

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

let me know is it clear to you.

 

thanks

 

 

MarkusWeick
Barite | Level 11

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?

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 19 replies
  • 1512 views
  • 0 likes
  • 2 in conversation