Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Compute Variance Qty

sgwong
Asteroide

Compute Variance Qty from source data and outo

1 RESPUESTA 1
CoG
Púlsar

Looking at your attachment, I am a little confused by the ask and wanted to verify the details. It appeared to be a simple case, where you separate the two datasets, Summarize them, then Join them back together, and use the Formula Tool to compute the difference between the two columns. 

 

That being said, the output sample you provided ignores the Date2 field completely and aggregates both Qty fields by grouping Date1 only. If this is the case only 1 Summarize tool is needed, and then the Formula Tool, and that's it.

 

Please provide clarification on your specific use case to receive better assistance. Thanks!

Encuestas
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Etiquetas