Seeing is Believing with Alteryx Visualytics Interactive Chart tool

[APolly]

You may be aware that Alteryx provides inline Visualytics that let you immediately visualize traditional, statistical and spatial data throughout your workflow to instantly validate your data.  If not, I highly suggest you check out this webinar to learn more.  With our latest release, 2018.3, you can now try our extended Visualytics capabilities with our Interactive Chart and Insight tools within the Reporting Suite.  In this article, we will focus on the Interactive Chart tool but search our Community to find helpful hints on our Insight tool.  

---

What can I do with Interactive Charts?

With the new Interactive Chart tool you can effectively communicate your analysis to people of all levels in your organization by creating visually appealing and easy to comprehend charts.  The resulting charts can be output to interactive formats such as embedding or viewing in an HTML site, viewing through the Alteryx Server or with interactive dashboards via the Insight tool.  Charts can alternatively be included in a static reporting format such as PDF or Excel.

Using this new capability, you can create a worldwide sales chart and embed into an HTML site so your stakeholders can zoom in to the regions or details that are important to them

With the Interactive Chart tool, you can easily build out the following types of charts:

• Area
• Bar
• Box & Whisker
• Candlestick
• Heatmap
• Line
• Scatter
• Pie

How do I use the Interactive Chart tool?

The Interactive Chart tool is a simple to use feature that lets you build multiple layers and customize the look and feel of your chart to meet your needs.  

1. From the Reporting suite of tools, simply drop the Interactive Chart   tool into your workflow 

2. Configure your chart by choosing the chart type, adding layers, changing fonts, colors and much more

 

3. Add Layer by giving it a name, choosing which type of chart and the data you want to visualize. If you want more than one layer to add dimensions to your charts, simply click add layer within the interactive chart tool.  Please note that you can add different chart types (ex. line and bar graph)

4. Customize the look and feel of your chart by adding labels, changing colors, fonts, size, gridlines and more to create the chart you need. You can also edit the text directly in the chart itself by clicking the chart title or axes titles and typing your desired text. 

5. As you build your chart you can explore the data interactively to ensure the data is showing in the way you expect. You can turn layers on/off from the chart legend, zoom in to specific parts of the data or rescale the axes.
6. If you need to create a similar chart for multiple audiences, you can use our powerful batching capabilities found in the reporting tools. This feature will create a new chart for each value in the group by field. (ex. One chart for each country in a region)
   
7. Often we need charts in similar formats and you can create a template to re-use the formatting or for faster chart creation in the Insight tool. 
8. It’s time to share your beautiful analysis! Output your chart by adding a browse tool to explore your chart, or another reporting tool such as Render to create your interactive HTML or static format like PowerPoint.

   

Ready to take our new Visualytics Interactive Charts experience for a spin?

Watch our hands-on Visualytics webinar to see it in action or try it for yourself by downloading our free trial or upgrading to 2018.3 today!

[mbarone]

Was trying to create some charts today.  No more stacked bar chart? 

[APolly]

Hi mbarone, Thanks for your feedback, we will keep this in mind as we enhance the new tool. We understant the importance for stacked bar charts. As an Ace, please join our beta program to provide feedback as early as possible. Alex Polly

[mbarone]

Thanks Alex!  I thought I had joined the betas; I'll double check though!

[mbarone]

Ah - I never clicked the 2018.4 beta.  I just did; thanks for bringing it to my attention!

[dbyfield]

Hi,

Any suggestions on resolving an "error parsing configuration" message? Further details on community post below:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Interactive-Chart-Tool-Error-Parsing-C...

Thanks

[APolly]

Hi dbyfield, I am following your other thread. When you are able to upload the workflow with dataset, we can reproduce on our side, and hopefully resolve your issue. Alex Polly

[dbyfield]

Hi alex,

The workflow with dummy datasets has been emailed to Support (as requested in the community post) so hopefully you'll be able to replicate.

FYI the issue was still occurring with the dummy datasets.

Thanks

David

[dbyfield]

Hi Alex,

Solution has now been posted to the Community thread - basically a manual line break in the Chart Title was the cause, and adding a specific HTML tag and removing any manual line breaks rectified the issue.

If a tool mastery article is being written for this tool, perhaps this can be mentioned within to ensure no one else encounters the same problem.

Thanks

David

[APolly]

Hi David,

Thanks for following up with us on this. And yes, good idea on the mastery article, I will take note and see where we can highlight this.

Alex Polly

[Debdatta]

How do I create a chart and the corresponding table in the same place so that they can be extracted to the same excel tab?

[APolly]

Hi Debdatta, You can use the Alteryx Table and Interactive Chart tools to create the Table and Chart and then output those to Excel using the render tool. Will that work for your need? Thanks, Alex Polly