Create a aggregate table

itahir04

Hi Alteryx community,

I am trying to calculate monthly work load of team members. 1 being 100% work load, .2 being 20% work load, etc. I need to analyze alteryx out put with tableau.

I have table like that:

Project ID	Project Name	User Name	Jan	Feb	March	April	May	June	July	August	Sep	Oct	Nov	Dec
1001	P1	Joe
1001	P2	Joe
1001	P3	Joe	1	1	0.6	0.3	0.3	0.3	0.3	0.3	0.3
1001	P4	Joe			0.2	0.2	0.2	0.35	0.35	0.35	0.3	0.25	0.25
1002	C1	Joe			0.2	0.2	0.2	0.35	0.35	0.35	0.2	0.25	0.25	0.3
1001	C2	Joe									0.2	0.5	0.5	0.7
1005	T1	Bob	1	1	0.6	0.3	0.3	0.3
1006	T2	Bob			0.2	0.2	0.2	0.35
1007	T3	Bob			0.2	0.2	0.2	0.35

In My out put file, I need Monthly workload of each team member- (Aggregate of monthly numbers for each user.)

for example Joe in March (.6+.2+.2) = 1 which is 100%

My Out put table should llook like:

Project ID

Project Name/WORK

User Name

Month

Allocation

Please give me an idea how can I get montly workload of each team member with my output table format.

Thanks,

Rana

rkapoor

Hi there

Have a look at the attached workflow example.

Workload_Example_itahir04.yxzp