¶ Dashboards
Dashboard - a way to visually present information in the database in the form of graphs, diagrams, maps and other understandable representations.
In the ozma.io dashboards areassembled in a "form" user view (@type = 'form') from other views:
- charts and diagrams;
- tables with aggregated data;
- forms with key indicators
Dashboard example:
Charts and diagrams are implemented using the functionality of iframes. If you are going to use charts in your dashboard, learn how to work with them in a separate article.
¶ Implementation
SELECT
@title = 'Dashboard',
@type = 'form',
-- Location and sizes of the blocks on the form
@block_sizes = [
4, 4, 4,
8, 4
],
{
ref: &analytics.deals_sources,
args: {
date_from: $$transaction_time - '1 week'::interval,
date_to: $$transaction_time
}
} as deals_sources @{
form_block = 0,
control = 'user_view'
},
-- ...
{
ref: &analytics.accounts_receivable,
args: {
date_from: $$transaction_time - '2 months'::interval,
date_to: $$transaction_time
}
} as accounts_receivable @{
form_block = 4,
control = 'user_view'
}
How to create a new dashboard:
- Plan the number of blocks, content and its location on the screen
- For each block, create a separate userview and implement an analytical view of data that describes a specific business indicator
- Create a new dashboard user view with type "form" -
@type = 'form' - Set the number of blocks and the size of each of them with
@block_sizes - Specify a reference (
ref) to each user view, arguments (args). Set block (usingform_block) and control type - user view (control = 'user_view')
¶ See also
- iframes - allows you to insert widgets into forms, implement charts and diagrams or embed a map on a form.