Alteryx Designer Discussions

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

How to create a line of text output with highest value

MJ54
7 - Meteor

I have a table that has two columns - 1 with dates for every day in the month and another with percentages.

 

I want to create a line on the bottom of the output that says something like “The date with the highest percentage is X”. How would I go about that?

5 REPLIES 5
binay2448
11 - Bolide

Please share some sample data for the same.

MJ54
7 - Meteor

Added the test data for visibility

RolandSchubert
15 - Aurora
15 - Aurora

Hi @MJ54 ,

 

should be something like that?

 

2021-09-15_17-55-23.jpg

 

You can find the highest value using the Sort and the Sample tool. A Report Text tool may be used to create the text and add it below the table.

 

2021-09-15_17-58-23.jpg

 

Let me know if it works for you.

 

Best,

 

Roland

MJ54
7 - Meteor

This looks like it may be what I am looking for. Would you be able to share another version of your sample workflow by any chance? I am unable to open it in my alteryx version. I would like to see the specifics for each individual function as I am new to them.

RolandSchubert
15 - Aurora
15 - Aurora

I've changed the version to 2019.3, hope this works for you.

 

Btw: You can change the workflow version by editing the .yxmd file using a text editor and replacing the version by the one you need:

 

2021-09-15_18-43-19.jpg

Labels