need to get average in a particular field.

Hello everyone i'm new to altery i'm stuck at a particular place please help.

Accepted answers

Apologies. Please find the correct workflow.

And workflow is 2019 version

I was able to prep up a workflow for the requirement.

I am able to get the same format but seems like the average in output is not actually a average.

Check and let me know. Hope this helps.

Cheers and Happy Analyzing : )

Thanks.

i'm unable to open the file. Please check the relative dependency part.

thank you

can u please send me the input file. bcoz when i'm using my input it showing error. The workflow is showing error in multi row column

I took another shot at it. Now i am getting the expected out in expected format.

Please check and let me know.

My Alteryx is 2020.1 if you want a lower version let me know i can downgrade it for you.

Cheers and Happy Analyzing : )

Can you mention which version ?