Skip to main content
Interania

Refining chart display results

0votes
22updates
51views

Interana 3.x provides a couple ways in which you can refine the display of the query results, without creating and running a new query.

This article demonstrates how to perform both of these tasks.

Hiding a measure

There may be times when you want to focus on results that doesn't include a measure, without having to create a new query. Interana 3.x provides a chart option that you can use to hide a measure with a single click, then redisplay the measure with equal ease.

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

This feature only applies to Time View, Table View, Bar View, and Sunburst View, but is not applicable for Number View and Sankey View.

To create and run a query with multiple measures, do the following:
  1. Click Explore in the left navigation bar, and then select a dataset from the drop-down list. In our example, we chose the movies database.
  2. Specify query builder options for the first measure, with the default name set 1. In our example, we chose Show count of events, that are Filtered to events with action that matches purchase_movie.

CB_Hide-Measure_Set1.png

  1. Specify query builder options for the second measure, with the default name set 2. In our example, we chose Show count of events, that are Filtered to events with action that matches watch_movie.

CB_Hide-Measure_Set2.png

  1. For the third measure (default name set 3), select Calculate from the drop-down list, then specify options and an operator for the calculation. In our example, we added the two sets together by specifying Calculate [set 1] + [set 2].

CB_Hide-Measure_Set3.png

  1. Select Split by options to group results. In our example, we selected to Split by action and activity.

CB_Hide-Measure_Split-by.png

  1. Specify Starting and Ending times for the query. In our example, we entered a Starting time of 365 days ago and an Ending time of now.

CB_Hide-Measure_Time.png

  1. Toggle to ALL, for an unsampled query, then click GO.

CB_Hide-Measure_ALL-GO.png

We received the following results for our example. We'd like to analyze the results further in another display format, such as Bar View, while hiding a selected measure.

CB_Hide-Measure_Results1.png

  1. At the top of the Results window, click the Bar View icon. The results changes to display in bar chart format.

CB_Hide-Measure_BarView.png

  1. Select Chart Options in the upper right corner, and click a measure check box to deselect, then click Apply. The results changes to show only the selected (checked) measures.

CB_Hide-Measure_Deselect1-1.png

We received the following results is in Bar View, and would like to drill into the the data further.

CB_Hide-Measure_Results1-1.png

  1. Optional: Further explore the data by clicking Chart Options and deselecting another measure, then clicking Apply. The results changes to show only the one selected measure.

CB_Hide-Measure_Deselect2-1.png

We received the following results for our example.

CB_Hide-Measure_Results2.png

  1. Optional: Click Time View to display the hidden measure results in that format.

CB_Hide-Measure_Results2_TimeView.png

Stacking bar charts

You can easily re-factor Bar View display results, grouping items together with the Stacked by option, without having to create a new query. Interana 3.x provides a chart option that allows you to group bar chart results, and then redisplay the original results with equal ease.

To group bar chart results, do the following:
  1. In the upper right corner of the query results window, click Chart Options.
  2. Select Stacked by none and choose an option to group by from the drop-down list. In our example, we chose to group the results by timestamp.
  3. Click Apply.

CB_ChartOptions_Stacked-by.png

We received the following results in our example.

CB_ChartOptions_StackedBy_results.png

  1. Optional: Make another Stacked by selection to regroup the results, or select none to return to the original display, then click Apply.

Displaying values on top of each bar

You can choose to 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. In the upper right corner of the query results window, click Chart Options.
  2. Click the Display value of each bar at the top check box, and then click Apply.

CB_ChartOptions_ShowBarValues.png

Values are displayed at the top of each bar in Bar View, as shown in the following example.

CB_ChartOptions_ShowBarValues_results.png

  1. Optional: Select Stacked by none and choose an option to group by from the drop-down list. The sum of all values stacked on the bar is shown. 
  2. Click Apply.

Hiding a line of results in Time View

When viewing query results in Time View, there may be times when you want to hide a single line that skews the results. You can do this with a single click, and then just as easily redisplay the line with another click.

To hide a line of results in Time View, do the following:
  1. Use the query you created in the previous task, Hiding a measure. We received the following results in Time View.

CB_Hide-Measure_Results1.png

  1. 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 this line from the drop-down menu. The graph display adjusts accordingly.

CB_Hide-Line_Menu1.png

  1. Optional: Individually select other lines to hide, choosing Hide this line 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?