This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.
Sparklines aren't built in to the Alteryx reporting tools, but you could leverage a VBA script that executes as an event "after workflow run" or from a run command tool after the Excel file has been created.
Like @BrandonB said, Spark Lines are a native Excel function and there's no built in way to set up the formatting on the excel spreadsheet to have them appear automatically
There are 2 other ways you can make it work however.
1. Set up a template Excel file that already has the Spark lines defined and the Grades 1 to 5 columns defined in a named range. Configure the output tool to insert the data into the named range. Once a user opens the Excel file, the spark line will be regenerated automatically.
2. You can reproduce the Spark lines functionality using the Alteryx reporting tools(I was bored)
Tricky part here is that you only have the headers show up at the top of the table and you need to group the Interactive Chart and the Table tools by student to line them up in the output. To do this you need to build a dummy Header record with only headers as a table and a dummy chart with white data lines and points Once you union this header row with the actual data rows, you have something that looks like this.
@danilang This is exactly what I was looking for, thanks a lot for your help! The second option fits my requirements better as we were looking to also have a brief snapshot to be sent out as email for the trend.