There is so much analysis possible within sql views including for performance monitoring, take advantage of all those SQL data analysis functions that are currently not available through pivot table. Unfortunately these analyses remain hidden away in the view and there is no way of showing them on the dashboard.
Fortunately there is [this ticket](Jira Link: [DHIS2-124] - Jira) that I feel can really resolve this issue and it would be great if prioritized for development.
I look forward to all your comments and support on this.
In the dashboard, add support for embedded SQL views and HTML reports. In other words, the output of the SQL view and HTML report should be rendered directly in a dashboard widget. It should be possible to search for SQL views and HTML reports in the search field based on the names of those objects.
Link: Jira Link: [DHIS2-124] - Jira