Alteryx Designer Desktop Discussions

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

Summarizing Stacked Data

AlisonK39
7 - Meteor

Hi, 

 

I've tried to find an answer on here - but maybe overthinking this issue.  I have two sets of data stacked - with the common factor being the "Contract" and I want to summarize the data at the Contract level.  Using the Summarize tool doesn't seem to be working for me, but I may be approaching it wrong.  It seems like this should be pretty basic, but I'm still somewhat "new" to Alteryx.  

 

 

AlisonK39_0-1610579884524.png

 

Thanks! 

 

2 REPLIES 2
Qiu
20 - Arcturus
20 - Arcturus

@AlisonK39 
Summarize should do the work.

Maybe your Team Hours columns are not numeric fields?

0114-AlisonK39.PNG

AlisonK39
7 - Meteor

Thanks so much!  I had previously tried the Summarize tool, but wasn't working as expect.  I just ran the workflow and the hours now look correct across reporting.  Appreciate the help! 

 

-Alison

Labels