I am creating a custom category from a category data item as I would like to do different groups.
group1 : AAA
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 ?
what do you want to do with the groups?
Maybe it's feasible to have one calculated item per group?
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.
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.
I recommend buidling a calcuated item for each group, which holds either the group member or a "missing".
Have you tried it:
In your example's terms:
If you uploaded an extract of your data, maybe I could give you a more specific example.
Hi, @vallsas ,
I can't see attachment.
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.
I defined group 1 as containing teh deaprtments AAA and BBB. Is the following what you want to see if you choose group 1:
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.
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?
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.