# Display record-specific charts in Analytics
### Creating a Chart on a specific record
Forest Admin’s dashboard is handy when it comes to monitoring the overall KPIs. But you may find the analytics module useful for a more in-depth examination of a specific company, user or any other items.
{% hint style="info" %}
“Analytics per record” are only supported in the API and Query modes.
{% endhint %}
* For Query charts, in agent v1, use the character `?` to inject the current record the user is currently seeing to your query. Meanwhile in agent v2, you must use `{{recordId}}`.
* For API charts, the parameter `record_id` is automatically passed in the HTTP body to access the record the user is currently seeing.
{% hint style="success" %}
A chart added on a record with such parameters will work for **all records**.
{% endhint %}
{% hint style="info" %}
To enable this feature in agent v2, your developers have to add a connection name into the datasources on which you want to execute live queries chart.
After that, you must select on which one you want to run the query.
{% endhint %}
{% hint style="warning" %}
For **security** reasons, only `SELECT` queries are allowed.
{% endhint %}
#### An example
In the following example, we compute the number of transactions per month for the company “Deliveroo”. The `companies.id` is an integer here, so there’s no need to quote it.
```sql
SELECT DATE_TRUNC('month', transactions.created_at) AS key, SUM(transactions.amount) / 100 AS value
FROM companies
JOIN transactions ON companies.id = transactions.beneficiary_company_id
WHERE companies.id = ?
GROUP BY key;
```
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.forestadmin.com/user-guide/dashboards/charts/analytics.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.