Alteryx Support needed

[surajseshan]

I have an alteryx requirement. i am stuck at a point now

i have summarised the values now and i need a subtotal by employee name against each employee. Also there are two conditions - Busy season (1/13/2025 to 3/10/2025) - any hours above 55 in subtotals get highlighted

Non - busy season - any hours above 40 in subtotals get highlighted

Finally we need to delete the rows that are not contributing to these subtotal of respective employees and make sure only the contributing hours rows are in the summary ( employee wise)

Appreciate your help at the earliest

Thank you

[Qiu]

@surajseshan 
It will be much better if you can provide a sample input and expected output?

[surajseshan]

sample input

Emp Resource  Name	Emp Resource  GPN	Rank Order	Emp Rank	Emp Grade	Emp Office	3/25/2024	4/1/2024	4/8/2024	4/15/2024	4/22/2024	4/29/2024	5/6/2024	5/13/2024	5/20/2024
abc	abc001	44	Staff	Staff 3	abc	0	0	8.583333	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	40	0	0	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	0	0	0	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	0	0	0	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	0	0	0	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	0	0	0	0	0	0	0	0	8
abc	abc001	44	Staff	Staff 3	abc	0	0	0	0	0	0	0	8	0
abc	abc001	44	Staff	Staff 3	abc	0	0	0	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	0	0	23.4	40	40	40	40	40	32

[surajseshan]

Expected output

Emp Resource  Name	Emp Resource  GPN	Rank Order	Emp Rank	Emp Grade	Emp Office	Sum_3/25/2024	Sum_4/1/2024	Sum_4/8/2024	Sum_4/15/2024	Sum_4/22/2024	Sum_4/29/2024	Sum_5/6/2024
abc	abc001	44	Staff	Staff 3	abc	0	0	8.583333	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	40	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	0	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	0	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	0	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	0	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	0	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	0	0	0	0	0	0	0
abc	abc001	44	Staff	Staff 3	abc	0	0	23.4	40	40	40	40
abc subtotal					40	0	31.98333	40	40	40	40

[surajseshan]

Last output

Now delete the rows employee wise that are not contributing to the hours of the employee and retain only the rows that actually contribute

consider these two

Busy season ((1/13/2025 to 3/10/2025) - any hours above 55 in subtotals get highlighted

Non busy season - any hours above 40 in subtotals get highlighted

[usmanbashir]

@surajseshan  - See attached workflow.  

Screenshot below is table produced with highlighting total row based on date and total conditions. I specified random dates/hours based on provided sample, in order to test it's working as expected - which it is.

Review Table tool conditions (update as you need based on dates and hours). Select on 'Dynamic or Unknown Fields' and select Edit next to Column Rules. Note there are two separate rules. Review the Formula to see the condition entered.

Keep in mind, it's a bit finnicky to test these rules on dynamic/unknown fields. If you make changes to the rule, I'd advise to update the regex replace in both Dynamic Renames to a random character, run workflow (this will clear the rules on the fields), update rule, then update back to original Dynamic Rename configuration provided, then re-run workflow to ensure your condition is working as expected. 

 

Hope this helps!

[surajseshan]

Basically i have worked out a summary. From the summary this needs to run .

Can you go a bit step by step so that i can include this to the actual input data

[surajseshan]

Thank you 

[usmanbashir]

I would recommend running the workflow I attached in the other comment and understand how the data is transformed (that’s the beauty of Alteryx!). You should be able to determine where your summary start would be and adjust the workflow from there. Good luck!