Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Tool Mastery

Explore a diverse compilation of articles that take an in-depth look at Designer tools.
Become a Tool Master

Learn how you can share your expertise with the Community

LEARN MORE

Tool Mastery | Charting

MattD
Alteryx Alumni (Retired)
Created
Charting.png

Note: The Charting Tool has been deprecated and replaced by the Interactive Chart Tool.

This article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Charting Tool on our way to mastering the Alteryx Designer:

As long as you know where to look, data has all the answers. Sometimes, though, those answers aren’t clear as day. More often than not, they need to be communicated in an effective format - a format that can let the data talk and highlight the important motifs for you. Another favorite of the Reporting Tool Category, the Charting Tool can do just that by adding expressive visuals to any report or presentation. Offering an exhaustive list of charts to choose from (area, stacked area, column, stacked column, bar, stacked bar, line, tornado, pareto, box and whisker, scatter, bubble, polar, radar, pie), the Charting Tool will give you the ability to add descriptive visuals, with legends and even watermarks, to your reporting workflows that will help you find the answers in your data.

moar.gif

How many charts do you need? More

Use the Charting Tool for:

  • Visualizing a data set (attached in Charting.yxmd)

Visualizing a data set.jpg

  • Automating reports for groupings of data (attached in the Charting.yxmd)

Automating reports for groupings of data.jpg

In this use case we simply took the same data from the first example and applied the Charting Tool’s “Grouping” feature to separate the reports by Region:

Grouping.jpg

You can create the same output reports, one to a pdf file, by using the Output Mode “Choose a Specific Output File” in the Render Tool and grouping on the same field:

Render Output.jpg

Like a charm, you have all your reports automated to output to each grouping in your data!

  • Data profiling (attached in the Charting.yxmd)

Similar to the data profiling features added in v11.0 of the Designer, you can use a combination of tools native to previous versions (like the Field Info or Field Summary Tools), along with the Charting Tool, to visualize metadata in your data sets:

11 Metadata.jpg

Data profiling in v11.0

Data profiling.jpg

By now, you should have expert-level proficiency with the Charting Tool! If you can think of a use case we left out, feel free to use the comments section below! Consider yourself a Tool Master already? Let us know at community@alteryx.com if you’d like your creative tool uses to be featured in the Tool Mastery Series.

Stay tuned with our latest posts every #ToolTuesdayby following @alteryxon Twitter! If you want to master all the Designer tools, consider subscribingfor email notifications.

Attachments
Comments
spainn
9 - Comet

We would like to create a chart to email out, hence using the charting in tool in Alteryx.  We want a line chart with 2 lines.  We would like to use 2 vertical axis, and 1 horizontal (date).  We would like one of the vertical axis to be a secondary axis.  We want 1 line to plot against the left hand axis and the other line to plot against the right hand axis.  This is standard functionality in Tableau but I can't see how to do this in Alteryx.  Any ideas?

M_G
7 - Meteor

A new Alteryx user - I'm trying to plot output data from an 'In-Db connection' using the Charting tool but it does not seem to work. Extracting data with 'Data Stream Out' tool, line shows its connecting to the Charting tool. But I don't get any fields to pick from the Configuration panel 'Select Fields to Chart' in the left. Trying to generate a Column chart, all I see is default 'Column' in the fields to pick and in the preview it just shows default Record1, Record2, Record3 and no actual data. What am I missing? 

patrick_digan
17 - Castor
17 - Castor

@M_G What is your field type? I'm just taking a stab in the dark, but if you put a select tool before your charting tool, I think you'll only see numeric (double, float, int) data show up in the charting tool as an available field to graph.

M_G
7 - Meteor

Workflow1.GIFPatrick,

There are only two fields in the data output. First one is a Code (string) and the other one is Count (numeric). I'm not using any select tool explicitly. I'm tapping into a large table through 'IN-DB Connection' filtering through a series of Filter In-Db as I've not figured out yet to put together a sophisticated filter. Then getting count with a Summary tool and getting output with 'Data Stream out' then plugging in the Charting tool. I've tried to attach an image of my workflow, not sure how it's going to show in the actual post.

Again, appreciate your feedback.

M_G

patrick_digan
17 - Castor
17 - Castor

@M_G Can you add a select tool between your data out and chart tool and screenshot the configuration? Like this:

 

Capture.PNG

AndyM
Alteryx
Alteryx

@M_G  Has the workflow been run since you added the Chart tool?  You may just need to run the workflow so it pushes the metadata from the In-DB tools into the Chart tool and then you can configure the Chart tool.

M_G
7 - Meteor

Workflow1.GIF@AndyM  Yes, workflow has been refreshed several times after adding new tools, and it shows data in the bottom window, but Charting tool still does not show the available fields.

 

@patrick_digan Added 'Select' tool as suggested. Showing Config panel for the 'Select' tool.

Select_Config.GIF

 

Select tool is showing data in the bottom window, but Charting tool still does not show the available fields.

 

M_G
7 - Meteor

@patrick_digan

Complete workflow with new 'Select' tool, showing data at the bottom, but still no fields available in Charting Tool Configuration.Chart_Config.gif

patrick_digan
17 - Castor
17 - Castor

@M_G I must be missing something obvious. I quickly setup an IN-DB test and it's working as expected on my end. I set it up and then ran it and it now gives me tho option for series 1 to have my field "Test".  All you pictures indicate that you should be having the same thing on your end, so I can't think of what could be wrong.

Capture.PNG

M_G
7 - Meteor

Hi @patrick_digan,

Yes, It sounds silly but I see the same default 3 records (Record1, Record2, Record3) in the Preview pane as you see in your sample. What I'm struggling with is how to show all (18 records in my case) records on the chart? This is the same data plotted in Excel, How do I get the charting tool to show the same in Alteryx.

Sample_Chart.GIF

patrick_digan
17 - Castor
17 - Castor

@M_G The preview pane is pretty hit or miss for me. If you put a browse after your chart tool, that will show you the actual chart then.

 

Your picture from yesterday shows that your label field is coming through, so I'm puzzled why your count field wouldn't as well. 

M_G
7 - Meteor

@patrick_digan Never mind the previous post. Yes, the Charting Tool was working all along, I just had to put yet another Browse tool after the Chart to see the results. Those little things that Experts like yourself take for granted don't come natural to beginners, I guess!

Once again, Thanks for your feedback and patience.

 

patrick_digan
17 - Castor
17 - Castor

@M_G Glad you were able to figure it out! I've been in your shoes plenty of times :)

tcroberts
12 - Quasar

Is there an easy way to display a chart from the charting tool directly in the workflow canvas without first saving it to file?

Pepper
8 - Asteroid

Can someone show how to do this on the new Interactive Charts tool?  I can not figure it out.  I have done the lines and they come out as records (so individual charts).  I need to have all the lines on one Chart using interactive.  

 

It would be great to show this example using the interactive chart tool.  

 

Thanks