Versions Compared

Old Version 3

changes.mady.by.user sivaji.ganesh

Saved on

compared with

New Version Current

changes.mady.by.user sivaji.ganesh

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open the panel menu for the Breakdown by category data table, then select Create drilldown.

  2. Click Go to dashboard.

    1. Give the drilldown a name. For example, View by category.

    2. From the Choose a destination dashboard dropdown, select Category Details.

    3. To use the geo.src filter, KQL query, and time filter, select Use filters and query from origin dashboard and Use date range from origin dashboard.

    4. Click Create drilldown.

  3. Save the dashboard.

  4. In the data table panel, hover over a value, click +, then select View Category Details.

Screenshot from 2024-05-17 08-46-33-20240517-031633.png

Screenshot from 2024-05-17 08-45-29-20240517-031529.png

Create URL drilldowns

URL drilldowns enable you to navigate from a dashboard to external websites. Destination URLs can be dynamic, depending on the dashboard context or user interaction with a panel. To create URL drilldowns, you add variables to a URL template, which configures the behavior of the drilldown. All panels that you create with the visualization editors support dashboard drilldowns.

Some panels support multiple interactions, also known as triggers. The variables you use to create a URL template depends on the trigger you choose. URL drilldowns support these types of triggers:

...

For example, Single click has {{event.value}} and Range selection has {{event.from}} and {{event.to}}.

...

Create a URL drilldown

For example, if you have a dashboard that shows data from a Github repositoryallows search in Google for a product, you can create a URL drilldown that opens Github Google search from the dashboard panel.

  1. Add the Sample web logs data.

  2. Open the [LogseCommerce] Web TrafficRevenue Dashboard dashboard.

  3. In the toolbar, click Edit.

    Create a donut chart

  4. Click Create visualization.

    5. From the Chart type dropdown, select Donut

    .

  5. From the Available fields list, drag machine.os.keyword to the workspace.

  6. Click Save and return.

  7. Open the donut chart panel menu for [Top products this week], then select Create drilldown.

  8. Click Go to URL.

    1. Give the drilldown a name. For example, Show on Github Search in Google.

    2. For the Trigger, select Single click.

    3. To navigate to the Kibana repository Github issues, enter the following in the Enter URL field:

      Code Block
      https://githubwww.google.com/elastic/kibana/issuessearch?q=is:issue+is:open+{{event.value}}

      Kibana substitutes {{event.value}} with a value associated with the selected pie slicerow value.

    4. Click Create drilldown.

  9. Save the dashboard.

  10. On the donut chart panel, click on any chart slicerow, then select Show on Github Search in Google.

  11. In the list of Kibana repository issues, verify that the slice value appears.google search, find the items which selected in kibana dashboard panel.

image-20240517-042046.pngImage Added

Create Discover drilldowns

Discover drilldowns enable you to open Discover from a Lens dashboard panel, taking the time range, filters, and other parameters with you so the context remains the same.

...

Discover drilldowns are supported only by Lens panels. To open all of the Lens dashboard panel data in Discover, check Open panel data in Discover.

Create the Discover drilldown

Create a drilldown that opens Discover from the Sample web logs data [Logs] Web Traffic dashboard.

  1. Click Edit, open the panel menu for the [Logs] Bytes distribution bar vertical stacked chart, then select Create drilldown.

  2. Click Open in Discover.

  3. Give the drilldown a name. For example, View bytes distribution in Discover.

  4. To open the Discover drilldown in a new tab, select Open in new tab.

  5. Click Create drilldown.

  6. Save the dashboard.

  7. On the [Logs] Bytes distribution bar vertical stacked chart, click a bar, then select View bytes distribution in Discover.

Discove

Manage drilldowns

Make changes to your drilldowns, make a copy of your drilldowns for another panel, and delete drilldowns.

  1. Open the panel menu that includes the drilldown, then click Manage drilldowns.

  2. On the Manage tab, use the following options:

    • To change drilldowns, click Edit next to the drilldown you want to change, make your changes, then click Save.

    • To make a copy, click Copy next to the drilldown you want to change, enter the drilldown name, then click Create drilldown.

    • To delete a drilldown, select the drilldown you want to delete, then click Delete.

URL templating

This functionality is in beta and is subject to change. The design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features.

...

Custom helper

Use case

json

Serialize variables in JSON format.

Example:

{{json event}}
{{json event.key event.value}}
{{json filters=context.panel.filters}}

rison

Serialize variables in rison format. Rison is a common format for Kibana apps for storing state in the URL.

Example:

{{rison event}}
{{rison event.key event.value}}
{{rison filters=context.panel.filters}}

date

Format dates. Supports relative dates expressions (for example, "now-15d"). Refer to the moment docs for different formatting options.

Example:

{{date event.from “YYYY MM DD”}}
{{date “now-15”}}

formatNumber

Format numbers. Numbers can be formatted to look like currency, percentages, times or numbers with decimal places, thousands, and abbreviations. Refer to the numeral.js for different formatting options.

Example:

{{formatNumber event.value "0.0"}}

lowercase

Converts a string to lower case.

Example:

{{lowercase event.value}}

uppercase

Converts a string to upper case.

Example:

{{uppercase event.value}}

trim

Removes leading and trailing spaces from a string.

Example:

{{trim event.value}}

trimLeft

Removes leading spaces from a string.

Example:

{{trimLeft event.value}}

trimRight

Removes trailing spaces from a string.

Example:

{{trimRight event.value}}

mid

Extracts a substring from a string by start position and number of characters to extract.

Example:

{{mid event.value 3 5}} - extracts five characters starting from a third character.

left

Extracts a number of characters from a string (starting from left).

Example:

{{left event.value 3}}

right

Extracts a number of characters from a string (starting from right).

Example:

{{right event.value 3}}

concat

Concatenates two or more strings.

Example:

{{concat event.value "," event.key}}

replace

Replaces all substrings within a string.

Example:

{{replace event.value "stringToReplace" "stringToReplaceWith"}}

split

Splits a string using a provided splitter.

Example:

{{split event.value ","}}

encodeURIComponent

Escapes string using built in encodeURIComponent function.

encodeURIQuery

Escapes string using built in encodeURIComponent function, while keeping "@", ":", "$", ",", and ";" characters as is.

URL template variables

The URL drilldown template has three sources for variables:

...

To ensure that the configured URL drilldown works as expected with your data, you have to save the dashboard and test in the panel. You can access the full list of variables available for the current panel and selected trigger by clicking Add variable in the top-right corner of a URL template input.

Variables reference

Source

Variable

Description

Global

kibanaUrl

Kibana base URL. Useful for creating URL drilldowns that navigate within Kibana.

Context

context.panel

Context provided by current dashboard panel.

context.panel.id

ID of a panel.

context.panel.title

Title of a panel.

context.panel.filters

List of Kibana filters applied to a panel.
Tip: Use in combination with rison helper for internal Kibana navigations with carrying over current filters.

context.panel.query.query

Current query string.

context.panel.query.language

Current query language.

context.panel.timeRange.from
context.panel.timeRange.to

Current time picker values.
Tip: Use in combination with date helper to format date.

context.panel.indexPatternId
context.panel.indexPatternIds

The data view IDs used by a panel.

context.panel.savedObjectId

ID of saved object behind a panel.

Single click

event.value

Value behind clicked data point.

event.key

Field name behind clicked data point

event.negate

Boolean, indicating whether clicked data point resulted in negative filter.

event.points

Some visualizations have clickable points that emit more than one data point. Use list of data points in case a single value is insufficient.

Example:

{{json event.points}}
{{event.points.[0].key}}
{{event.points.[0].value}} {{#each event.points}}key=value&{{/each}}

Note:

{{event.value}} is a shorthand for {{event.points.[0].value}}
{{event.key}} is a shorthand for {{event.points.[0].key}}

Row click

event.rowIndex

Number, representing the row that was clicked, starting from 0.

event.values

An array of all cell values for the row on which the action will execute. To access a column value, use {{event.values.[x]}}, where x represents the column number.

event.keys

An array of field names for each column.

event.columnNames

An array of column names.

Range selection

event.from

from and to values of the selected range as numbers.
Tip: Consider using date helper for date formatting.

event.key

Aggregation field behind the selected range, if available.