Alteryx Support needed

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

Workflow

Accepted answers

All comments

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_solution.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703