Create a Dashboard

[ravikumar060987]

Need help urgently, Wanted to create a Dashboard 1 and 2 below. I know how to create 1... Please guide me how to create a Dashboard 2. Hereby shared sample data.

Received 3 type of instructions every day. Say A, B & C.

Team behaviour

Some days only A instruction came, B & C are NULL

Some days only B instruction came, A & C are NULL

Some days only C instruction came, A & B are NULL

Some days A & B instruction came, C is NULL

Some days A & C instruction came, B is NULL and so on…..

But, I need to create the dashboard for A, B & C as final result. Wherever the instruction not came, those Variable marked as ‘0’.

Table 1			Table 2
Variable	Constant		Variable	Constant
A	1		A	1
A	3		A	3
A	5		A	5
B	1		C	5
B	2		C	6
B	3		C	7
C	5
C	6
C	7
Dashboard 1			Dashboard 2
A	9		A	9
B	6		B	0
C	18		C	18

[Joe_Lipski]

A potential solution attached using a join to find missing data and then a union to add back in missing data (e.g. a right outer join)

[ravikumar060987]

Thank you @Joe_Lipski for the solution... To make 1 more step in it.

Now, I have below set data... How to create this...

Variable	Types		Variable	Types
A	Type 1		A	Type 1
A	Type 2		A	Type 2
A	Type 3		A	Type 3
B	Type 1		C	Type 1
B	Type 2		C	Type 2
B	Type 1		C	Type 3
C	Type 1
C	Type 2
C	Type 3
Variable	Type 1	Type 2	Type 3		Variable	Type 1	Type 2	Type 3
A	1	1	1		A	1	1	1
B	2	1	0		B	0	0	0
C	1	1	1		C	1	1	1

[Joe_Lipski · Accepted solution]

You will need to use the Cross-Tab tool in this scenario.

Update attached and you can vote on the idea here of allowing a count in a cross-tab tool with non numerical values as this would have removed the need for the formula:  https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Cross-Tab-Aggregate-Values-Using-Count-on-Te...

Cheers,

[ravikumar060987]

Thank you.. @Joe_Lipski