In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

getting max %

mzubair9402
6 - Meteoroid

Hi all,

 

I have a bunch of data in one column with numbers words percent and etc. I need to extract the max tax rate percent for each row. I tried the sum function but not all data being pulled is correct. Can you please help.

12 REPLIES 12
Maskell_Rascal
13 - Pulsar

Make sure that Date is selected in the Transpose Tool and Select Tools. Sometimes they drop off when downloading a workflow from another user. 

Maskell_Rascal_0-1624652168457.png

 

apathetichell
19 - Altair

Its' worth noting that the data you posted is fairly different than the data your workflow was designed for - that has an effect on the how the workflow is developed. Your workflow had text fields and needed the first 4 rows cut off to be used - the data you posted didn't need that work and was already numbers. This changes how the workflow is developed and the tools used - the key component though is getting a date/group field and getting the tax rates into a double format (whether natively or via multi-field) and then using a summarize.

mzubair9402
6 - Meteoroid

Thank you all for your help.

Labels
Top Solution Authors