Skip to main content
Interania

1.2 Modify a query

0votes
32updates
63views

You can modify a query in the following ways:

This article demonstrates both methods, started with the query example from create a board and add a panel

Modify a query from Explore view

This section demonstrates how to use Explore view to modify the query you constructed to create a board and add a panel, and discover how many actors there were over the last 7 days. 

When you modify a query in Explore view, you can pin the new query to your board as a new panel while retaining the original query.

To modify a query in Explore view, do the following:
  1. From the board you created, click the Explore icon in the left navigation panel. The details for the query you created appear on the left.
  2. Make sure the dataset you used initially is still selected in the upper left corner. In our example, we chose the IA_MOVIES dataset.
  3. For Show count, select user (Actor) from the drop-down list. Filter to automatically changes to all user actors.

1.2_Show-count_actors_menu-options2.png

  1. Leave the following settings as is: Split by none, Starting 7 days ago, and Ending now.

A trailing window (the default is 1 day) specifies how far back from each data point's end time the data server should look when aggregating over events. We used the default in this example, so we did not specify a trailing window.

  1. Click GO. We receivied the following results for our query.

1.2_query-results2.png

  1. Click the Pin to board icon—circled in the previous example—to pin the query to your board as a new panel.

Modify a query from a panel 

This section demonstrates how to modify the query you used to create a board and add a panel, directly from the panel and discover the number of sessions that reached a 30 minute timeout over the last 7 days.

When you modify a query in a panel you can save the resulting query, but it replaces the original query panel with the newly modified query.

To modify a query from a panel, do the following:
  1. Make sure the dataset you used to create a board and add a panel is selected. In our example, we chose the usage dataset.
  2. From the board you created, click the Edit icon in the upper right corner of the query panel.

1.2_Edit-panel-icon.png

  1. Click the Edit icon that appears in the menu bar on the left. You are taken to Explore view, showing the query in the panel on the left.

1.2_Edit-icon-Edit-panel.png

  1. For Show count, select action from the drop-down list.
  2. For Filter to, select Session (30 minute timeout), and leave the default reached state in session.
  3. Leave the following settings as is: Split by none, Starting 7 days ago, and Ending now.
  4. Click GO to run query.
  5. Click Save in the upper right corner, to save the modifications.

What's Next

Now that you're comfortable constructing and modifying basic queries, you're ready to learn how to create properties for use with more complex queries:

  • Was this article helpful?