In this tutorial we will be doing an example dashboard we will use the sales table.
Creating a dashboard
In order for the dashboard to contain these applications, they must first be created as follows:
1 – Application of Bar Graph showing sales by region.
1.1 – Create an application of the Graphic type
1.2 – Select the following dimensions and metrics:
1.3 – In “Chart Type” select “2D Bar”.
1.4 – Generate the source of the application.
2 – Application of an analytical graph showing the sales made by an employee, in comparison with all sales.
2.1 – Create a new Graph application.
2.2 – Use the SQL below.
SELECT orderid, orderdate, 'All Employees' AS groupby, priceorder FROM orders UNION SELECT orderid, orderdate, '[emp_label]' AS groupby, priceorder FROM orders WHERE employeeid = [emp]
2.3 – Select the following dimensions and metrics:
2.4 – In “Type of Graph” select “2D Bar”, and below, check the option “Multi-series”.
2.5 – Generate the source of the application.
3 – Search displaying Order data.
3.1 – Create a new Grid application based on the “orders” table.
3.2 – In Grid modules, we use only the “Grid” module, with the configurations below:
3.3 – Next, we create a link to the chart created in step 2.
- Field link in “employeeid”:
3.4 – Manage the source of the application.
4 – Finally, we are going to create the Dashboard application and join the previously created applications.
4.1 – Create a new Dashboard application.
4.2 – Add 2 more connection widgets and select the applications that we need to show inside the panel.
10 – Finally we save the changes and run the application.