Visualizing Data

Overview

The Visualization module in NetSpring offers a layer for executing, viewing, and customizing visual data and charts that display exploration results. This module is consistent across all exploration templates and offers the same properties and options for viewing and customizing data. In addition, some elements from the Visualization module are also included in the Visualization Tiles when used in the Dashboard.

Visualization Options

Let's explore the different visualization options:

• Select/Switch Chart Types
• Edit Visualization using Chart Settings
• Inspect Underlying Query
• Add Chart to Dashboard
• Refresh Data

info

To view these options, hover over the chart/data in the visualization module.

Chart Types

NetSpring provides several chart types to help you visualize your data. These charts can be used in dashboard or exploration to present data effectively. You can modify the chart type by selecting the chart types button, which appears when you hover over the visualization.

Chart Type	Description
	Displays a single value derived from analysis. You can use this chart type for top values and aggregated calculations and analysis.
	Displays data in tabular format.
	Displays data in two-dimensional chart with an X and Y axis, each point representing a single value. The data points are joined by a line to depict a trend, usually over time.
	Displays data as rectangular bars, with the bar length indicating the magnitude of the value. The "dimension" is plotted along the vertical axis, while the "measure" is plotted along the horizontal axis.
	Displays data as rectangular bars, with the bar length indicating the magnitude of the value. The "dimension" is plotted along the horizontal axis, while the "measure" is plotted along the vertical axis.
	Displays data across multiple stages in a process in a bar chart layout.
	Displays data across multiple stages in a process.
	Displays data in a circle that is segmented into sectors, with each sector representing a proportion of the entire data
	Displays data points using bubbles that incorporate an additional data dimension, which is conveyed by the size of the bubbles.
	Displays the flow from one set of values to another. It is useful for discovering frequent user journeys showing their paths through different touch points with a product, e.g. different screens, actions, etc.
	Displays table data in a multi-dimensional view.

Chart Settings

The Chart Settings section allows you to customize and edit your chart. You can access these settings by selecting the Edit visualization option from the "more" menu (three vertical dots) located in the dashboard tiles and exploration templates.

• Visualizing Data
  • Overview
  • Visualization Options
    • Chart Types
    • Chart Settings
      • Visualization Tab
        • Automatic Refresh
        • Chart Type
        • Axis tab
        • Plot tab
      • Parameters Tab
      • Sorting Tab
    • Inspect Query
    • Add to Dashboard
    • Refresh
  • Visualization Configuration Example

Visualization Tab

Automatic Refresh

This option allows you to turn on/off automatic refreshing of the chart's data. To activate it, use the toggle and specify the time interval for refreshing in the Refresh rate field.

info

It is necessary to configure the Refresh rate. If left empty, Automatic Refresh will not be enabled.

Chart Type

The Chart type option enables you to select your desired chart type.

info

See Chart Types for descriptions and images.

Axis tab

The Axis tab enables you to select and customize the data you want to visualize on the chart axis.

note

For Pie Chart, Table, or Sankey Chart, the X-Axis and Y-Axis tabs get replaced by Primary and Secondary tabs.

• X-Axis or Primary Axis

  tip

  Use + to add more data columns on x-axis.

  
  • Axis Label: allows you to override the source column name and have a custom label for x-axis.
  • Axis Scale Type: allows you to choose an axis measurement unit.
  • Format: allows you to choose a data format for displaying values on the axis.
  • Max Label Rotation: allows you to control the label's rotation.

• Y-Axis or Secondary Axis

  tip

  Use + to add more data columns on y-axis.

  
  • Display Axis: allows you to control the display of the axis in the chart.
  • Axis Label: allows you to override the source column name and have a custom label for x-axis.
  • Axis Scale Type: allows you to choose an axis measurement unit.
  • Format: allows you to choose a data format for displaying values on the axis.
  • Color: allows you to change the color of the data displayed on the axis.
  • Point Size: allows you to change the size of data points displayed on the sparkline in a line chart.
  • Line Width: allows you to control the width of the sparkline in a line chart.
  • Line Tension: allows you to control the curve of the sparkline in a line chart.
  • Fill: allows you to fill color in the sparkline's area.
  • Stepped: allows you to change to a stepped line chart.
  • Apply color to value: allows you to apply the selected color to the value in a Single Value chart.
  • Conditional Coloring: allows you to add conditional coloring to certain data points that you want to stand out in the chart.

• Color: allows you to represent the selected data using colors.

  tip

  Use + to add data columns for displaying their data points using different colors on the chart. The data column you select also form the legend if it is enabled.

  
  • Axis Label: allows you to override the source column name and have a custom label for data points on the chart.
  • Value Colors: allows you to display specific values in the chosen color.

• Tooltip: A tooltip is a message containing data values that appears when you hover over data points to view information.

  tip

  Use + to select data columns for displaying their values in the tooltip.

  
  • Axis Label: allows you to override the source column name and have a custom label in the tooltip.
  • Format: allows you to choose a data format for displaying values on the chart.

• Size (Bubble Chart only): Choose the bubble size for the Bubble Chart.

  tip

  Use + to select data columns to indicate their values through size of bubbles in the chart.

  
  • Axis Label: allows you to override the source column name and have a custom label for data points on the chart.
  • Format: allows you to choose a data format for displaying values on the chart.

Chart tab

The Chart tab enables you to customize the visual configuration for your chart's plot area.

• Display Legend: allows you to control display of legend on the chart.
• Display Sparkline (Single Value Chart only): allows you to display the sparkline along with the single value.
• Prefix and Suffix (Single Value Chart only): allows to prefix and suffix any string to the single value.
• Display Value (Single Value Chart only): allows you to control the display of the value.
• Font Size (Single Value Chart only): allows you to control the font size of the value
• Set color on background (Single Value Chart only): allows you to fill color in the background.
• Compact Layout (Single Value Chart only): allows you to switch to a compact layout.
• Bar Thickness (Bar and Column Chart only): allows you to control the bar thickness.
• Stacked Bar Chart (Bar and Column Chart only): allows you to change to a stacked bar chart layout.
• Donut Chart (Pie Chart only): allows you to change to donut chart layout.
• Show Data Labels (Pie Chart only): allows you to control the display for data labels inside the pie chart.

Sorting Tab

Use the Sorting tab to enable/disable the sorting option on the chart.

You can use the Show sorting option on graph option to display the sorting button on the chart. The arrows next to each column enable you to sort the data quickly. Additionally, you can use the Limit option to restrict the data displayed.

Inspect Query

This option enables you to examine and customize the underlying exploration query in NetScript, SQL, and Warehouse SQL dialects.

You can access this option from the "more" menu (three vertical dots). You can also open the query in the explorer to modify it.

info

To customize the query, use the Open as * Explore button. When you click this button, you are directed to the relevant explorer:

• For Warehouse SQL, it directs you to the data warehouse.
• For SQL, it directs you to the SQL Explorer.
• For NetScript, it directs you to the NetScript Explorer.

Add to Dashboard

This option enables you to add the current exploration to a new or an existing dashboard. It is available in all exploration templates and simplifies the process of adding charts to dashboards.

Here is how it works:

Refresh

This option enables you manually refresh the chart at any time. When you hover over the refresh button, you will be able to see when the query was computed last.