Formula into Alteryx

Hello All,

Could anyone help me to design a flow for below - mentioned PBI formulae? you can use a sample number. Please assist me to replicate this into the Alteryx flow.

Table.Group(Source, {"Customer ID/Quarter"}, {{"Max Sales Count", each List.Max([#"Sales Count - Deal Level"]), type nullable number}, {"Min Sales Count", each List.Min([#"Sales Count - Deal Level"]), type nullable number}, {"RRR", each List.Sum([RRR FX]), type nullable number}})

Thanks,

Help

Accepted answers

All comments

Raj

Drag and drop the "Group By" tool onto your Alteryx workflow.
Connect the "Group By" tool to the "Input Data" tool that contains your source data.
In the "Group By" configuration, select the "Customer ID/Quarter" field as the grouping field.
Add the following three aggregate functions in the "Group By" tool:

Max Sales Count: use the "Max" option and select the "Sales Count - Deal Level" field.
Min Sales Count: use the "Min" option and select the "Sales Count - Deal Level" field.
RRR: use the "Sum" option and select the "RRR FX" field.

Run the workflow and the output will be a new data set that is grouped by the "Customer ID/Quarter" field, with the Max Sales Count, Min Sales Count, and RRR calculated for each group.

this should work for you

Raj

or provide the data set if errors in process

Learner09

Thank you @Raj, there is no tool as "group by", I can see the tool 'make group' which consists of only two keys

binu_acs

@Learner09 @Raj was referring the summarize tool, in which you will see the group by option

Raj

@binu_acs thanks for clearing

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167