You can refine the display of the query results, without creating and running a new query, in several ways:
- Hide a measure—Use a chart option to hide and then redisplay an entire measure.
- Stack bar charts—Group the results in Bar View displays with the Stacked by chart option.
- Display values on top of each bar—Show the values on top of each bar. Stacked bars show the sum of all values for the bar.
- Hide a line of results in Time View—Toggle a line of results in Time View on and off.
This article demonstrates how to perform each of these tasks.
Hiding 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.
This feature is supported in Time View, Table View, Bar View, and Sunburst View. It is not available in Number View or Sankey View.
To create and run a query with multiple measures, do the following:
- 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.
- Specify query builder options for the first measure, with the default name measure 1. In our example, we chose Show count of events, filtered to events with action that matches purchase_movie.
- Specify query builder options for the second measure, with the default name measure 2. In our example, we chose Show count of events, filtered to events with action that matches watch_movie.
- For the third measure (default name measure 3), click Show and select Calculate, then specify options and an operator for the calculation. In our example, we added the two sets together by specifying Calculate [measure 1] + [measure 2].
- Select Split by options to group results. In our example, we selected to Split by action and activity.
- Specify Starting and Ending times for the query. In our example, we entered a Starting time of 365 days ago by typing and an Ending time of now.
- Toggle to ALL, for an unsampled query, then click GO. 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.
- At the top of the Results window, click the Bar View icon. The results changes to display in bar chart format.
- 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.
We received the following results is in Bar View, and would like to drill into the the data further.
- 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.
We received the following results for our example.
- Optional: Click Time View to display the hidden measure results in that format.
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:
- In the upper right corner of the query results window, click Chart Options.
- 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.
- Click Apply.
We received the following results in our example.
- 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 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:
- In the top right corner of the query results window, click Chart Options.
- Click the Display value of each bar at the top check box, and then click Apply.
Values are displayed at the top of each bar in Bar View, as shown in the following example.
- 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.
- 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:
- Use the query you created in the previous task, Hiding a measure. We received the following results in Time View.
- In the legend on the right, select the line of results you want to hide. The line is highlighted in the graph display.
- Choose Hide this line from the drop-down menu. The graph display adjusts accordingly.
- 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.