Report Formatting Questions: Sorting and Report Title

Question

Hello,

I'm having trouble configuring formatting for a report I'm working on.

My data tables are shown in the report randomly, rather than ascending order. I have about 20 area IDs, but the tables are showing in random order. The second issue is that the Report Header is showing before every table. I only want it as the title of the entire report, not before every table. I tried configuring this in the Layout tool in multiple ways but I wasn't able to figure it out.

Thanks!

Area.JPG

alteryx workflow.JPG

Alefiyah · Answer

I think I figured it out.

I added a sort tool to the beginning of my workflow which solved the problem.

As for the Header, I replaced it with the Text Tool after the Table Tool, and it seems to be working fine now.

Qiu · Answer

@Alefiyah

Not likely, but if you are using Union Tool to bring the Area ID together, you should check the option of "Set a Specific Output Order".

And as for the title, if you are using the Header option, you also need to check one option.

Without seeing the actual flow, it is hard to say anything though. 😁