Explore data in Chronograf
Explore and visualize your data in the Data Explorer. For both InfluxQL and Flux, Chronograf allows you to move seamlessly between using the builder or templates and manually editing the query; when possible, the interface automatically populates the builder with the information from your raw query. Choose between visualization types for your query.
To open the Data Explorer, click the Explore icon in the navigation bar:
Select local time or UTC (Coordinated Universal Time)
- In the upper-right corner of the page, select the time to view metrics and events by clicking one of the following:
- UTC for Coordinated Universal Time
- Local for the local time reported by your browser
Note: If your organization spans multiple time zones, we recommend using UTC (Coordinated Universal Time) to ensure that everyone sees metrics and events for the same time.
Explore data with InfluxQL
InfluxQL is a SQL-like query language you can use to interact with data in InfluxDB. For detailed tutorials and reference material, see our InfluxQL documentation.
Limited InfluxQL support in InfluxDB Cloud and OSS 2.x
- Open the Data Explorer and click Add a Query.
- To the right of the source dropdown above the graph placeholder, select InfluxQL as the source type.
- Use the builder to select from your existing data and allow Chronograf to format the query for you. Alternatively, manually enter and edit a query.
- You can also select from the dropdown list of Metaquery Templates that manage databases, retention policies, users, and more. See Metaquery templates.
- To display the templated values in the query, click Show template values.
- Click Submit Query.
Explore data with Flux
Flux is InfluxData’s new functional data scripting language designed for querying, analyzing, and acting on time series data. To learn more about Flux, see Getting started with Flux.
Open the Data Explorer and click Add a Query.
To the right of the source dropdown above the graph placeholder, select Flux as the source type. The Schema, Functions, and Script panes appear.
Use the Schema pane to explore your available data. Click the + sign next to a bucket name to expand its content.
Use the Functions pane to view details about the available Flux functions.
Use the Script pane to enter your Flux query.
To get started with your query, click the Script Wizard. In the wizard, you can select a bucket, measurement, fields and an aggregate.
For example, if you make the above selections, the wizard inserts the following script:
from(bucket: "telegraf/autogen") |> range(start: dashboardTime) |> filter(fn: (r) => r._measurement == "cpu" and (r._field == "usage_system")) |> window(every: autoInterval) |> toFloat() |> percentile(percentile: 0.95) |> group(except: ["_time", "_start", "_stop", "_value"])
- Alternatively, you can enter your entire script manually.
Click Run Script in the top bar of the Script pane. You can then preview your graph in the above pane.
Visualize your query
Select the Visualization tab at the top of the Data Explorer. For details about all of the available visualization options, see Visualization types in Chronograf.
Add queries to dashboards
To add your query and graph to a dashboard:
- Click Send to Dashboard in the upper right.
- In the Target Dashboard(s) dropdown, select at least one existing dashboard to send the cell to, or select Send to a New Dashboard.
- Enter a name for the new cell and, if you created a new dashboard, the new dashboard.
- If using an InfluxQL data source and you have multiple queries in the Data Explorer,
select which queries to send:
- Active Query: Send the currently viewed query.
- All Queries: Send all queries.
- Click Send to Dashboard(s).
Metaquery templates provide templated InfluxQL queries manage databases, retention policies, users, and more. Choose from the following options in the Metaquery Templates dropdown list:
Measurements, Tags, and Fields
- Show Field Key Cardinality
- Show Measurement Cardinality
- Show Series Cardinality
- Show Tag Key Cardinality
- Show Tag Values Cardinality
Manage retention policies
Manage continuous queries
Manage users and permissions
Inspect InfluxDB internal metrics
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for Chronograf and this documentation. To find support, the following resources are available: