Having overall KPIs displayed on your dashboard is great, but sometimes you might need to get analytics on a specific user, item, etc. You can do that by adding a chart right inside a record.
These charts are created the same way you would do it in dashboard tab. Here's the step-by-step guide:
What is different, though, is that when creating a chart on a specific record using SQL, you would have to enter this record's token. Identifying a token is pretty easy - it's the last digits of your hash in the address bar. Copy the digits and select the character Token
to inject the current record to your query.
Token в Simple
Перейдите в Simple -> нажмите '+ Add Filter', из списка из Value выберите Token.
Token в SQL
Перейдите в SQL -> Для выбора Token нажмите на кнопку Token и выберите нужный параметр
selectdate_trunc('month', start) AS gr,sum(amount)fromrideleft jointransactiononride.transaction_id=transaction.idwhereride.vehicle_id={{model.id}}group by grorder by gr;