Tutorial: Sales dashboard by region

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.