Hello Everyone! I'm trying out the reporting functionality in Alteryx and I wanted to see if anyone knows a better way to go about what I'm doing. I'm creating a summary report that highlights the change in record count throughout my process, so users can easily see how we got from point A to point B. I'm currently using the Sum tool throughout the workflow to get the record count at a certain point and then appending them all together and spitting them out on a report.
I have 2 questions:
1) Is there an easy way to join data together that have no columns in common while maintaining everything on one row? All of my data points that I'm joining will only have 1 value and 1 column. My current workflow looks like this and I hate having to use so many append tools because I want to join even more data points together and its going to get messy quickly:
I tried using a multi join tool, but since there are no columns in common each individual data set ends up on its own row like so:
2) Are there any templates out there for summarized reports? I'm terrible at formatting and making things look "pretty". My current report is just using some text with basic variable inputs. I'm planning on adding a company logo and maybe changing fonts, but wanted to see if anyone knew of any cool templates out there that I can take a look at:
