Unsure how to proceed to compute a variance

[kimberlyka]

Hi all!

The backstory of my workflow is that I have two different Excel files that I am ultimately trying to join and derive a variance for each row in the file.

I added a 'TAG 1' in both files, which will ultimately compute a unique identifier for each row in the file; and will match across. I cleaned up both files to ultimately show only the TAG 1 as well as the PQ1-PQ9 values. I want to prompt Alteryx to compute a variance for each row based on the unique identifier. How can I go about this?

Currently, the files have not been joined together as the 'Join' tool is not triggering anything to connect.

Thank you so much in advance!

[mceleavey]

Hi @kimberlyka ,

Can you please post some mock data so we can help?

Thanks,

M.

[kimberlyka]

Hello! 

Two sample files are attached and Tag 1 is set within a formula tool: [CPAS ID] + [Business Division] + [Sub Segment 1] + [Sub Segment 2]

[Qiu]

@kimberlyka 

I think I have created the Tag for comparation, but dont know how to compute a variance as your mentioned.

[apathetichell]

Did you want a variance vs mean PQ1-PQ9 by tag? I wasn't quite sure what you wanted - and obviously in the sample data the variance will end up being 0 since the data is all the same.