Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Average for multiple conditions

Dennis229
7 - Meteor
‎01-11-2023 10:55 AM

Hey there. I am trying to find the average for a column based on two conditions, but want the work flow to be dynamic if multiple conditions were added in the future. 

I basically want to replace the 2 summarize with a single tool but not sure what to use. 

 

test.yxmd
Labels:
Reply
4 REPLIES 4
Felipe_Ribeir0
16 - Nebula
‎01-11-2023 10:56 AM

Hi @Dennis229 

 

Please attach the input file

Reply
0 Likes
Dennis229
7 - Meteor
‎01-11-2023 11:00 AM

here

17 KB
Reply
Felipe_Ribeir0
16 - Nebula
‎01-11-2023 12:13 PM

Hi @Dennis229 

 

One way of doing this is by using a batch macro

 

Felipe_Ribeir0_0-1673468006415.png

 

test (1).yxzp
Reply
binuacs
21 - Polaris
‎01-11-2023 01:37 PM

@Dennis229 one way of doing this with the analytic app

 

binuacs_0-1673473552657.png

 

Review_011123.yxzp
Reply
register for inspire
designer new user guide
Labels
Top Solution Authors
View All