Correlations editor in Explore

In your Amazon Managed Grafana workspace, navigate to the Explore page.

Select a data source that you would like to be the source for a new correlation.

Run a query producing data in a supported visualization.

Choose + Add in the top toolbar and select Add correlation (you can also select Correlations Editor from the Command Palette.

Explore is now in Correlations Editor mode indicated by a blue border and top bar. You can exit Correlations Editor by choosing Exit in the top bar.

You can now create the following new correlations for the visualization with links that are attached to the data that you can use to build a new query:

Choose a link to add a new correlation. Links are associated with a field that is used as a result field of a correlation. For more details, see Correlation configuration.

In the split view that opens, use the right pane to set up the target query source of the correlation. For more details, see Target query.

Build a target query using variables syntax with variables from the list provided at the top of the pane. The list contains sample values from the selected data row.

Provide a label and description (optional). A label will be used as the name of the link inside the visualization and can contain variables.

Provide transformations (optional; see below for details).

Choose Save in the top toolbar to save the correlation and exit Correlations Editor mode. The link used to create the correlation is replaced with a data link in each row. When the link is selected, the query you defined will run in another pane, with the variables replaced dynamically with the values from the selected row.

Select a field to apply the transformation to. Select the portion of the field that you want to use for the transformation. For example, a log line. Once selected, the value of this field will be used to assist you in building the transformation.

Select the type of the transformation. See Correlation Transformations for the options and relevant settings.

Based on your selection, you might see one or more variables populate, or you might need to provide more specifications in options that are displayed.

Select Add transformation to correlation to add the specified variables to the list of available variables.

In Grafana, navigate to Explore.

Select the test data source from the dropdown menu at the top left of the page.

Choose + Add in the dropdown menu to the right and select Add correlation.

Explore is now in Correlations Editor mode, indicated by a blue border.

Select the following scenario from the scenario dropdown menu: CSV File.

Select the file, population_by_state.csv. Each cell is a link that you can click on to begin creating a new correlation.

Click on any cell in the State column to create a new correlation that attaches a data link to that entry. For example, select California.

In the split view, select the same data source you selected in the left pane. The helper above the query editor contains all available variables you can use the target query. Variables contain all data fields (table columns) from the selected row.

In the Scenario menu, select CSV Metric Values. The String Input field in the Query editor provides variables with population values for each year: ${1980},${2000},${2020}. This will generate a graph using variable values.

In the Query Editor Alias field, enter ${State}.

Run a query to see that it produces a graph using sample values from the variables.

Choose Save to save the correlation and exit the Correlations Editor.

After the correlation is saved, Explore will rerun the query in the left pane. By clicking a state name, the query on the right is rerun with values from the row being inserted into the CSV, thus changing the graph. The query is rerun with updated values every time you click on a state name.

In Grafana, navigate to Explore.

Select the test data source from the dropdown menu at the top left of the page.

Choose + Add in the dropdown menu to the right and select Add correlation.

Explore is now in Correlations Editor mode, indicated by a blue border.

In the Scenario menu, select Logs.

Expand a log line to see the correlation links. Select Correlate with hostname.

Explore opens in split view. Select the same data source you selected in the left pane. The helper above the query editor contains all available variables you can use the target query.

Expand the transformations section, and click Add transformation.

In the Field dropdown menu, select message. The log line shows up as example data.

Under Type, select Logfmt. This populates the list of variables.

Choose Add transformation to correlation.

Choose Add transformation again and under Field, select hostname.

Under Type, select Regular expression.

Under Expression, enter the following: -([0-9]\*). This selects any numbers to the right of the dash.

Under Variable Name, enter the following: hostNumber. This populates the list of variables.

Choose Add transformation to correlation to add it to the other variables.

In the data source editor, open the Scenario dropdown menu and select CSV Content.

In the text box below, provide the following and save the correlation:

time,msg,hostNumber,status
${time},${msg},${hostNumber},${status}

This closes the split view and reruns the left query. Expand any log line to see the correlation button. Chooseing the correlation button opens the split view with the time (a field), msg (extracted with logfmt from the log line), host number (extracted with regex from the hostname) and the status (extracted with logfmt from the log line).