How to create a line of text output with highest value

Question

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?

RolandSchubert · Answer

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:

LineBelowTable.yxmd

MJ54 · Answer

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 · Answer

Hi @MJ54 ,

should be something like that?

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.

Let me know if it works for you.

Best,

Roland

LineBelowTable.yxzp