Skip to main content
Interania

1.2 Modify a query

0votes
34updates
72views

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 180 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. In the upper left corner, select a dataset. In our example, we chose the 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_unique_options2.png

  1. Leave the following settings as is: Split by none settings as is
  2. Click the Starting text and enter 180 days ago and accept Ending now.

1.2_Time-settings.png

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 did not specify a trailing window for this example.

  1. Click GO, then click the Pin to board icon, to pin the query to a board as a new panel. 

1.2_Query-results_Pin-to-Board.png

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 180 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 movies 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 Split by none settings as is.
  4. Select the Starting text and enter 180 days ago, and accept Ending now.
  5. Click GO to run query, then 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?