Display record-specific charts in Analytics
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
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.
A chart added on a record with such parameters will work for all records.
For security reasons, only SELECT
queries are allowed.
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.