topic Re: sas viya3.5 va 8.5.1 - Custom Category in SAS Visual Analytics

sas viya3.5 va 8.5.1 - Custom Category

vallsas — Tue, 23 Aug 2022 09:45:09 GMT

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 ?

Re: sas viya3.5 va 8.5.1 - Custom Category

MarkusWeick — Tue, 23 Aug 2022 17:07:38 GMT

Hi @vallsas,

what do you want to do with the groups?

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

Best

Markus

Re: sas viya3.5 va 8.5.1 - Custom Category

vallsas — Tue, 23 Aug 2022 17:32:46 GMT

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

Re: sas viya3.5 va 8.5.1 - Custom Category

MarkusWeick — Tue, 23 Aug 2022 20:01:48 GMT

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?

Re: sas viya3.5 va 8.5.1 - Custom Category

vallsas — Wed, 24 Aug 2022 03:44:22 GMT

Yes, you are right!

Re: sas viya3.5 va 8.5.1 - Custom Category

MarkusWeick — Wed, 24 Aug 2022 06:01:07 GMT

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

Re: sas viya3.5 va 8.5.1 - Custom Category

MarkusWeick — Wed, 24 Aug 2022 10:37:17 GMT

Have you tried it:

In your example's terms:

Re: sas viya3.5 va 8.5.1 - Custom Category

vallsas — Wed, 24 Aug 2022 11:52:24 GMT

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

Re: sas viya3.5 va 8.5.1 - Custom Category

MarkusWeick — Wed, 24 Aug 2022 12:11:46 GMT

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

Re: sas viya3.5 va 8.5.1 - Custom Category

vallsas — Wed, 24 Aug 2022 18:15:30 GMT

Hi, Bruehl
pls find attached file thanks

Re: sas viya3.5 va 8.5.1 - Custom Category

MarkusWeick — Wed, 24 Aug 2022 18:52:43 GMT

Hi, @vallsas ,

I can't see attachment.

Best

Markus

Re: sas viya3.5 va 8.5.1 - Custom Category

vallsas — Thu, 25 Aug 2022 09:05:49 GMT

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)

Re: sas viya3.5 va 8.5.1 - Custom Category

MarkusWeick — Thu, 25 Aug 2022 11:16:08 GMT

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:

Re: sas viya3.5 va 8.5.1 - Custom Category

vallsas — Thu, 25 Aug 2022 12:58:41 GMT

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

Re: sas viya3.5 va 8.5.1 - Custom Category

MarkusWeick — Thu, 25 Aug 2022 14:25:24 GMT

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?

Re: sas viya3.5 va 8.5.1 - Custom Category

MarkusWeick — Thu, 25 Aug 2022 14:31:42 GMT

I think there are tow tasks:

First, having overlapping groups (which doesn't work in one costum category).

Second, showing different columns based on a button bar selection.

(For the second task @Sam_SAS showed a nice workaround in Solved: Creating dynamic measures in stacked bar chart - SAS Support Communities)

Re: sas viya3.5 va 8.5.1 - Custom Category

vallsas — Thu, 25 Aug 2022 18:18:39 GMT

Hi @MarkusWeick
I mentioned in the first post as custom_column diffferet groups and all in one group in the same custom column so that i can use in button bar.
Cutom_cat_colum
group1 : AAA
BBB
CCC
group2 :GGG
EEE
Group3: DDD
FFF
Group4:AAA
BBB
CCC
DDD
EEE
FFF

as we are already selected the values into different groups then we dont have a option to create group4 in the custom_category because the values we are already moved to group1 group2 group3 and GROUP4 is all the group values. so we cant create a group4.
sorry for the confusion. hope in the last post you have got clear idea what is needed.
thanks
t

Re: sas viya3.5 va 8.5.1 - Custom Category

MarkusWeick — Mon, 29 Aug 2022 06:43:10 GMT

Hi @vallsas,

please give the following apporach a try:

1.1 Button bar for selection of parameter values

1.1.1 Defining and uploading the values for the Buttons

We build an Excel file (“Groupings 2.xlsx”) with one column which contains the possible parameter values, which we want to show on the buttons of the button bar under a column name:

We then upload this table into VA.

1.1.2 Definiton of a character parameter

We define a new data item as parameter of type “Character” and name it “Choice”

1.1.3 Definition of a button bar

We drag a button bar object to the report page.

Before we assign the roles to the button bar, we activate the table with the values we want to assign with the button bar:

Then we assign the roles to the button bar:

2.1 Calculated item which contains the chosen group

Now we define a “new calculated item”:

With nested if-clauses we get a column which contains the values for the group which is defined by the choice in the button bar (via the parameter):

1.4 Creating an object that shows the calculated item

If we want to omit the line with the missing values, we can add a filter to the list table and deactivate the “Include missing values” option:

Re: sas viya3.5 va 8.5.1 - Custom Category

MarkusWeick — Wed, 19 Oct 2022 19:20:54 GMT

Hi @vallsas,

did it work for you?

Best

Markus

Re: sas viya3.5 va 8.5.1 - Custom Category

vallsas — Fri, 21 Oct 2022 19:37:56 GMT

Hi Markus,

department	task_list
aaa	1001
bbb	1002
ccc	1003
ddd	1004
ccc	1004
ccc	1005

there is no column which contains groups with all value , so I cant choose in the if condition to select the values.

requirement is : when we use button bar by department we get as per the example: 5 dep and on the same button bar we would like to have All so when user would like to see statistics of all the all the departments stats then he will choose all otherwise dept.

as we don't have all in the new customized category as I have created custom category to define the 5 groups and in the custom category we dont have options to choose all as one group.