Documentation Index
Fetch the complete documentation index at: https://help.loopiq.com/llms.txt
Use this file to discover all available pages before exploring further.
Create Metrics, Custom Charts, and Dashboards
What this does
This guide explains how to create reusable analytics assets in LoopIQ:- metrics
- saved charts
- custom dashboards
Create a metric
Use Metric Library when you want a reusable metric that can be shared across charts and dashboards.- Open Analytics.
- Go to Metric Library.
- Click Create Metric.
- Enter a metric name and description.
- Build the SQL formula by:
- writing SQL directly, or
- using plain-English SQL generation
- Validate the SQL.
- Save the metric.
Use schema guidance while writing SQL
When writing or editing a query, LoopIQ shows approved tables, views, and columns for the active analytics database. Use that schema guide to understand what fields are available before running a query. This is especially helpful when you are:- building an ad hoc chart
- editing a default dashboard query
- creating a new reusable metric
Create a custom chart
Custom Charts supports several creation paths:- build from one saved metric
- combine multiple saved metrics into one chart
- write ad hoc SQL
- generate SQL from plain English
Typical flow
- Open Analytics → Custom Charts.
- Choose how you want to start.
- Build and run the query.
- Configure chart fields such as x-axis, values, and series mapping.
- Review the preview.
- Save the chart.
Combine multiple metrics into one chart
LoopIQ supports multi-metric chart creation. You can:- select multiple saved metrics
- choose which fields each metric maps to in the chart
- rename each series
- reorder metrics to control how they display
- remove a metric and replace it with another
Create a custom dashboard
- Go to Analytics → Dashboards.
- Create a new dashboard.
- Add widgets using saved charts.
- Set widget titles and layout size.
- Reposition or remove widgets as needed.
- Save the dashboard.
- remove widgets
- add new widgets
- reposition widgets
- swap a widget to a different saved chart
Share dashboards
Custom dashboards can be shared within the same organization:- directly with specific users
- with teams
- as viewer
- or as editor