Skip to main content
Interana Docs

Modify a query

You can modify a query in the following ways:

This article demonstrates modifying a query from Explore view and from a panel, starting 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 Explore in the left navigation panel. The details for the query you created appear on the left.
  2. For Show count, select an actor from the drop-down list. In this example, our actor field is named userFiltered to automatically changes to all user actors.

1.2_SHOW_count_unique_options2.png

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

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

  1. Click GO to validate the query, then click the pin 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 gear icon in the bottom right corner of the query panel to open the slider.
  3. Click the Edit icon that appears in the menu bar on the left.
    1.2_Edit-icon-Edit-panel.png
    You are taken to Explore view, showing the query on the left.
  4. Next to Show count, select action from the drop-down list.
  5. Next to Filter to, select Session (30 minute timeout), and leave the default reached state in session.
  6. Leave the Split by none settings as is.
  7. Select the Starting text, enter 180 days ago, and accept Ending now.
  8. Click GO to run query, then click Save at the top 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?