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”:

- Parameters:

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.

Comment this post