Visualize Laravel App Data with Chartello
Published on by Paul Redmond
Chartello is a package to visualize your Laravel app data in simple dashboards:
You can create multiple dashboards to break up charts; for example, you could have a Sales dashboard and a Support dashboard. On the dashboards, you can create two kinds of panels:
- Trend Charts
You can populate a trend chart using the following query, which contains placeholders for start and end dates:
SELECT DATE(created_at) AS x, COUNT(*) AS yFROM usersWHERE created_at BETWEEN @start AND @endGROUP BY xORDER BY x ASC
The placeholders mean your dashboards will adjust based on the selected date ranges for providing trend-based charts.
Table charts are more flexible as they can virtually accept any select combination of data and list the columns in a table:
This package also comes with a middleware to limit access to dashboards. You can configure authorization for the Chartello dashboard based on any custom logic you'd like.