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.

Alteryx Designer Discussions

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

Create Sparklines for Excel Reports

jineshnp31
8 - Asteroid

Hi! 

 

I am looking for a solution to build sparklines for a trend report in Excel. Given is what I am looking to build.

Is there a way to use the Reporting tools to visualize a trend over time for each category as below?

 

jineshnp31_1-1608733254228.png

 

Reference: https://www.ablebits.com/office-addins-blog/2019/10/02/excel-sparklines-insert-change-use/

 

Appreciate any help!

 

Thank you.

BrandonB
Alteryx
Alteryx

Hi @jineshnp31 

 

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. 

 

Example of sparklines VBA: https://myengineeringworld.net/2012/09/create-sparklines-automatically.html

 

Execute VBA from a workflow: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Run-Command-Executing-Excel...

danilang
17 - Castor
17 - Castor

Hi @jineshnp31 

 

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)

w.png  

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.

 

o.png

 

Dan

jineshnp31
8 - Asteroid

Thank you @BrandonB I will try this solution as well, it actually also helps me think about automating another process! Appreciate it! 🙂 

jineshnp31
8 - Asteroid

@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.

Appreciate your help! 🙂

Labels