- Creating a new board
- Constructing a query
- Pinning the query to create a panel
1. Creating a new board
This section shows you how to create a new board that you can populate with your own query panels. New boards and panels are private by default in Interana 3.9 and later.
To create a new board, do the following:
- From the Interana UI, click the Boards icon in the top left navigation panel.
2. Click +New at the bottom of the list of boards.
3. In the Name Your Board dialog, enter a unique name for the board (perhaps including you Interana username), optionally add a description, and click Save.
An empty board displays with the following message.
4. Continue with Constructing a query.
2. Constructing a query
Next we'll define a query, then pin the results to our board to create a panel. This section demonstrates how to create a query that shows how many events you had over the last seven (7) days.
Think of an Interana query as a mathematical equation made up of words, and the word segments as query building blocks. The building blocks we use to create the query in this example are:
- Show count of events—the total number of events.
- Filtered to all events—we are not using any filters (or comparisons), we are querying all events.
- Split by none—we are not filtering the results by an actor, action, or property.
- Starting 7 days ago—we start our count 7 days ago.
- Ending now—ending the count right now.
To create a query that shows all events over the last seven days, do the following:
- Click the Explore icon in the navigation bar. The Interana default query page appears.
- Select a dataset from the drop-down list in the top left corner. Your available datasets will be for your company data. In our example, we chose a dataset called movies.
- In the first line of the query, select Show, count, and events from the drop-down lists if they're not already selected.
- For Filtered to, select all events.
- Split by should be set to none.
- For Starting select 7 days ago, and for Ending select now.
- For with time options, leave the default value of 1 day.
A trailing window (the default is 1 day) specifies how far back from each data point's end time Interana looks when aggregating over events.
- Select Sampled or All (for an unsampled query), then click GO. The query results appear on the right.
- (Optional troubleshooting step) If no query results appear, check the time scrubber at the bottom of the page. The time scrubber graphs the number of events across time in your dataset. Depending on your dataset, you might need to drag the start and end time markers to a time range that contains data.
- Continue with Pinning the query to create a panel.
3. Pinning the query to create a panel
In the previous task, you successfully completed constructing a query, and the results are shown on the right.
This task demonstrates the various ways you can view query results, then pin the query to the board as a panel. Query results are displayed in Time view by default, as shown in the following example.
To view query results in different formats and then pin the query, do the following:
- In the default Time view, hover the cursor over points on the line to view detail data, as shown in the example above.
- To view query results in table format, click the Table view icon at the top of the window.
- Click the other visualization format icons to view the query results in different formats. Click again on your favorite visualization.
- Name your query by editing measure 1 above the first line of the query and clicking Go again.
The description above the visualization updates to include the new name.
- To create a panel of the current query that will appear on your board, click the Pin to board icon at the top right of the page.
- Choose the board you created in Creating a new board. The panel displays dynamically updated results for the the query.
Next, you'll want to Modify a query.