Visualization

The visualization module in Analytics lets you execute, view, and customize data and charts that show exploration results. Additionally, when you use Visualization Tiles in the Dashboard, some elements from the visualization module are included.

Visualization options

Analytics offers several chart types to help you visualize your data. You can use these charts in dashboards or explorations to present your data. To change the chart type,

Click the chart icon in the visualization window and select the chart type.

Single Value

The Single Value chart displays a single value derived from analysis. This chart type is used for top values, aggregated calculations, and analysis.

Table

The Table displays data in tabular format.

Line Chart 

The Line Chart displays data in a two-dimensional format with an X and Y axis. Each point represents a single value, and the data points are connected by a line to illustrate a trend, typically over time. See also Visibility controls.

Horizontal Bar Chart

The Horizontal Bar Chart displays data as horizontal 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.

Bar Chart

The Bar Chart displays data as vertical 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. See also Visibility controls.

Bar Funnel Chart

Using a bar chart layout, the Bar Funnel Chart displays data across multiple process stages.

Funnel Chart

The Funnel Chart displays data across multiple stages of a process.

Pie Chart

The Pie Chart displays data in a circle segmented into sectors, each representing a proportion of the data.

Bubble Chart

The Bubble Chart displays data points using bubbles, incorporating an additional data dimension represented by the size of the bubbles.

Sankey Chart

The Sankey Chart illustrates the flow from one set of values to another. Showing users' paths through various touchpoints with a product, such as screens, actions, and more, is useful for identifying frequent user journeys.

Breakdown Chart

The Breakdown Chart shows retention by time dimensions – time since focal time and time itself. This capability is present only for the Retained measure type. You can also segment by cohorts and attributes in the breakdown chart.

Pivot Chart

The Pivot Chart displays table data in a multi-dimensional view.

Visibility controls

You can show or hide specific measures or attributes from your visualizations without modifying the underlying query. This gives you flexibility in viewing and presenting data, which is especially useful in crowded charts.

In experiment scorecards, you can toggle and save visibility settings for decision-making and guardrail metrics. Special pivot attributes used in scorecards also surface, allowing more control over what is displayed in performance comparisons over time.

Chart settings

You can customize and edit your chart through the chart settings section. Click More (⋮) > Edit visualization in the dashboard tiles and exploration templates.

Data tab

The data tab has information about the X and Y axes and lets you select and customize the data you want to display on the chart axis. Click + corresponding to the respective axes to add an axis configuration. You can add attributes and tooltips by clicking +. For the pie chart, table, or sankey chart, primary and secondary tabs replace the x-axis and y-axis tabs.

Sorting

Use the Sorting section to sort your visualization results. 

Use the Show sorting option on the graph to display sorting on the chart. The arrows next to each column let you sort the data. You can also use the Limit option to restrict the data displayed.

Automatic refresh

Toggle the automatic refreshing of the chart's data. To activate it, use the toggle and set the time interval in the Refresh rate field. If left empty, automatic refresh is not enabled.

Style tab

General

You can configure the following options:

• Display legend – Control the display of the legend on the chart.
• Legend position – Configure where you want to position the legend. The options available are Top, Bottom, Left, and Right.
• Stacked chart – Display values for different categories stacked on top of each other within a bar or along a single axis.
• Compact layout – Create Sparklines to visualize trends across multiple measures with compact, in-line charts to spot patterns and gain insights at a glance.
• Tooltip mode – Configure the tooltip position. The options available are Nearest, X-axis, Y-axis, and Index.

X-axis

You can configure the following fields:

• Display axis – Control how the axis displays in the chart.
• Column label – Edit the name of the column.
• Axis label – Override the source column name with a custom label for the X-axis.
• Axis scale type – Select a measurement unit for the axis.
• Format – Select a data format for displaying values on the axis.
• Ticks time unit – Adjust the axis time markers or "ticks" without changing the time grain.
• Max label rotation – Control the rotation of the labels.

Y-axis

You can configure the following fields:

• • Display axis – Control how the axis displays in the chart.
  • Column label – Edit the name of the column.
  • Axis label – Customize the axis label by overriding the default source column name.
  • Axis scale type – Select the measurement unit for the axis.
  • Axis position – Select the position of the axis.
  • Calculate % of Total – Enable this option to see the results in percentage format.
  • Format – Select how data values are formatted and displayed on the axis.
  • Max decimal precision – Configure the maximum number of digits shown after the decimal point in numerical values.
  • Value Rounding – Edit your visualization and round large values into millions, billions, or trillions to keep data readable. 
  • Axis range maximum – Configure the maximum range for the axis.
  • Axis range minimum – Configure the minimum range for the axis.
  • Color – Change the color of the data displayed on the axis.
  • Point size – Adjust the size of data points on a line chart's sparkline.
  • Line width – Control the width of a sparkline in a line chart.
  • Line tension% – Adjust the curvature of a sparkline in a line chart.
  • Fill – Add color to the area under a sparkline.
  • Stepped – Switch to a stepped line chart.

Attribute

• Column label – Override the source column name and have a custom label in the tooltip.
• Format – Select a data format for displaying values on the chart.

Tooltip

Display data values when you hover over data points. Use + to select data columns to display their values in the tooltip.

• • Axis label – Override the source column name and have a custom label in the tooltip.
  • Format – Select a data format for displaying values on the chart.

Inspect query

You can examine and customize the underlying exploration query using NetScript, SQL, and Warehouse SQL dialects. To do this, click More (⋮) > Inspect Query. You can also open the query in the explorer to modify it.

To customize the query, click Open as Explore. You are directed to the relevant explorer:

• For Warehouse SQL, go to the data warehouse.
• For SQL, go to the SQL explorer.
• For NetScript, go to the NetScript explorer.

Add to Dashboard

You can add the current exploration to a dashboard. This feature is available in exploration templates and simplifies adding charts to dashboards.

Refresh

Click Refresh to refresh the chart. Hover over Refresh to see when the query was last computed.