Insight Tool Icon

Insight Tool

Version:
Current
Last modified: May 12, 2020

Use the Insight tool to create interactive dashboards to use to gain deeper insights into your data. You can create and arrange multiple charts and text elements on the dashboard, create filters for viewing specific data, and create drilldowns to let you change the detail level of data displayed. When you use the filters and drilldowns to view data, all related charts in the insight dynamically update. The insight can be published to a Gallery for others to view.

Configure the Tool

Run the workflow to read the data into the Insight tool, and then select Configure Insight to open the configuration window. An insight can include one or more chart and text elements, filters, and drilldowns.

Create an Insight

  1. Run the workflow.
  2. Select Configure Insight.
  3. Drag a Chart or Text element and drop it on the page.
    • Create a Chart
      1. Hover over the chart element and select Edit.
      2. Under Create > Layer, select Add Layer.
      3. Enter a Name for the layer.
      4. Select chart Type.
        • Area: Displays a relationship of how data changes over time.
        • Bar: Displays categorical data with rectangular bars of heights or lengths proportional to the values they represent.
        • Box and Whisker: Displays groups of numerical data distributed by their quartiles.
        • Candlestick: Displays the price movements of a financial asset for a specific period.
        • Heatmap: Displays a map in which data values are represented as colors.
        • Line: Displays information as a series of data points connected by straight line segments.
        • Scatter: Displays values that show the correlation between two numerical sets of data.
        • Pie: Displays data as a circle divided into slices to represent a numerical proportion.
      5. Select columns to use as the values for the X and Y axes. To create an interactive chart, where you can drill down from summary data, and view different levels of details about the data, use a drilldown for the X or Y axes. To create a Drilldown...
        • Under Create > Drilldown, select Create Drilldown.
        • Enter a Name for the drilldown.
        • Select the fields to include in the drilldown.
        • Under Create > Layer, select Add Layer
        • Select the drilldown to use as the value for the X or Y axes.
        • Split Data into Multiple Layers:
          • Under Create > Transforms, select Split to separate data into multiple layers and style each layer of a chart based on the number of different values within a column.
          • The Transforms option is available for Area, Bar, Box, Line, and Scatter charts.
      6. For aggregations or calculations of the data, select a Field and Function. Options include Sum, Count, Min, Max, Mean.
      7. Under Style, select to configure the Default Font, Layer, Sort, Chart, Axes, Legend, and Notes:
        • Font: Select the font, font size, and font color for the chart. Edits made to the font for the chart title, axes titles and labels, legend text, and notes will override the default font.
        • Layer: Select colors, show the layer in a legend, and show values when the cursor hovers over a data point on the chart. Many of the options depend on the type of chart selected.
        • Sort: Select a field and click Ascending or Descending to sort data on the chart.
        • Chart: Select the size, background color, margins, and padding for the chart, and add a chart title.
        • Axes: Add a title for each axis, and show grid lines and labels. The font for the axes titles and labels can be customized.
        • Legend: Show a legend for the chart, and select the legend box font, color, and location. Click and drag the legend to move it to a new location on the chart. For a layer to show in the legend, it must be enabled under Style > Layer.
        • Notes: Add a note and arrow to the chart. Select and drag the note to move it to a new location on the chart.

          The chart title, axes titles, legend text, and notes can be edited by selecting them directly on the chart. Add a link to text by specifying a URL. Hover over the area at the top of the Insight window to view Zoom, Pan, Zoom in, Zoom out, Reset axes, Toggle Spike Lines, and Save as PNG options.

      8. Select Close Editor to close the chart editor and save changes.
    • Create a Stacked Bar Chart: A bar chart displays categorical data with rectangular bars of heights or lengths proportional to the values they represent. A stacked bar chart displays an extra level of detail within a simple bar chart and allows you to see how subgroups of data contribute to the total. To create a stacked bar chart...
      1. Run the workflow.
      2. Select Configure Chart in the tool configuration window.
      3. Under Create > Layer, select Add Layer.
      4. Select the chart Type of Bar.
      5. Select columns to use as the values for the X and Y axes.
      6. Under Create > Transforms, select Split.
      7. Select the column to split the data on.
      8. Under Style > Layer, select Stack from Bar Mode.
    • Save and Import a Chart Template: Save a chart and all settings as a template, which you can import into an Insight tool or a different Interactive Chart tool in a workflow.
      • ​​​​To save a chart as a template...
        1. Under Create, select Template.
        2. Enter a Template Name.
        3. Select Save.
      • To import a saved template...
        1. Under Create, select Template.
        2. Select the name of the template.
        3. Select Import.
    • Add a Text Element
      1. Drag a text element and drop it on the page.
      2. Hover over the text element, select in the text box, and enter text.
      3. Select Close to close the text editor.
  4. Add, edit, or delete elements on the page.
    • To move an element on the page, hover over the element, select, and drag the element to a different location.
    • To resize an element, hover over the element, select the resize handle, and drag it in any direction.
    • To delete an element from the page, hover over the element, and select the trash can icon.
  5. Add a filter to select data that meets specific criteria.
    1. Select Filters in the right-hand pane, and select + Filter.
    2. Select a column via the Column Name dropdown.
    3. Enter a name in Filter Name.
    4. Select a Filter Control. Options include Dropdown, Multiselect, and Date Range.
  6. Select Preview to view the completed insight, and to interact with the data in the chart. If you added a drilldown, you can select an area of a chart to drill down to the next level of detail and select Reset to return to the summary view of data.
  7. Select the "X" icon to close the Insight window and return to the workflow.

Publish and Share an Insight

You can publish an insight to a Gallery and share it in a collection so others can view and interact with it.

Best Practices for Publishing an Insight

  • Include the name of the workflow as part of the name of the insight for easy reference when viewing the insight in the Gallery.
  • Add an annotation to an Insight tool in a workflow for an insight that will be published to the Gallery to easily track published insights.
  • Publish the insight to the Gallery first, and then save the workflow to the Gallery. This creates an insight ID and establishes the relationship between the insight and the workflow. At this point, you can run or schedule the workflow to refresh the data for the insight.
  • Once a workflow and an insight have been published, modifying the Insight tool in the workflow and publishing it again will overwrite the existing insight in the Gallery. To publish a new insight to the same Gallery, you must configure a new Insight tool in the workflow.

When you publish an insight to a Gallery, the insight is saved in the Insights tab. To publish an insight follow the below steps.

Publish an Insight

  1. Create an insight with a chart or text element.
  2. Select Select Gallery.
  3. Select the name of the Gallery and select Publish.
  4. In Save Insight, enter the Insight Name and select Save.
  5. Sign in to the Gallery and select the Insights tab to view the published insight.
  6. Select the name of the insight to view and interact with the data.

You can share an insight with users by adding it to a collection. To share an insight follow the below steps.

Share an Insight

  1. Select Collections and add a new collection.
  2. Select the name of the collection.
  3. Select the Users tab, enter the user name, and select the user to share the collection with.
  4. Select the Insights tab, enter the insight name, and select the insight to add it to the collection.

Users can view the insights they have shared with others from within their collection but must view the insights shared with them from the Insights tab.

Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.