Skip to main content

 

Interana Docs

Refine chart display results

Whenever you run a query and get results, you are presented with chart options at the top of the results pane. The chart options are separated into three sections:

  • Display options
  • Format options
  • Additional options specific to the chart type, app, or view.

Use combinations of these options to create a variety of visualizations.

This article describes a few basic tasks:

See the Adjust display options section in Analyze a distribution for information about chart options in the Distribution app.

Hide a measure

There might be times when you want to focus on results that don't include a measure, without having to create a new query. You can hide a measure with a chart option, then redisplay the measure.

This section shows you how to create and run a query with multiple measures, then hide individual measures to further analyze the data.

To hide a measure, do the following:
  1. In Explore, create and run a query with multiple measures. For examples of how to do this, see Determine a ratio in the Tutorial or Calculate DAU and MAU.
  2. Select Chart Options in the top right corner.
    Screen Shot 2020-03-20 at 6.35.25 AM.png
  3. Click a measure check box to deselect, then click Apply. The results change to show only the selected (checked) measures.
    Screen Shot 2020-03-20 at 6.00.55 AM.png

Stack bar charts

You can refactor Bar View display results, grouping items together with the Stacked by option, without having to create a new query. Use a chart option to group bar chart results, and then redisplay the original results with equal ease.

To stack bar chart results, do the following:
  1. Create and run a query with multiple measures. For examples, see Determine a ratio and Calculate DAU and MAU.
  2. In the top right corner of the query results window, click Chart Options.
  3. Scroll to the Additional Bar View Options section of the window. 
  4. Next to Stacked by, select none and choose an option to stack by from the drop-down list. In our example, we chose to stack the results by measure.
    Screen Shot 2020-03-20 at 6.17.15 AM.png
  5. Click Apply. We received the following results in our example.
    Screen Shot 2020-03-20 at 6.18.06 AM.png
  6. Optional: Make another Stacked by selection to regroup the results, or select none to return to the original display, then click Apply.

Display values on top of each bar

You can show and hide values on top of each bar in Bar View. For stacked bars, the sum of all values stacked on the bar is shown.

To show values on top of each bar, do the following:
  1. Create and run a query, and display it in bar view.
  2. In the top right corner of the query results window, click Chart Options.
  3. Click the Display value of each bar at the top check box, and then click Apply.
    Screen Shot 2020-03-20 at 6.37.51 AM.png

    Values are displayed at the top of each bar in Bar View, as shown in the following example.
    Screen Shot 2020-03-20 at 6.39.41 AM.png
    In a stacked bar chart, the number displayed at the top of each bar is the sum of all values in that bar.

Hide a line of results in Time View

When viewing query results in Time View, you might want to hide a single line that skews the results.

To hide a line of results in Time View, do the following:
  1. In Explore, create and run a query with multiple measures. For examples of how to do this, see Determine a ratio in the Tutorial or Calculate DAU and MAU.
  2. In the legend on the right, select the line of results you want to hide. The line is highlighted in the graph display.

CB_Hide-Line_Select-line1.png

  1. Choose Hide from the drop-down menu. The graph display adjusts accordingly.
  2. Optional: Individually select other lines to hide, choosing Hide for each. You can hide as many lines of results as necessary to analyze the data. We chose to hide three lines in our example, and received the following results.

CB_Hide-Line_Results3.png

 

 

  • Was this article helpful?