Data Panel Dashboard (DPD)

Data Panels

Single Value

Single value data panels are designed to display a single value to users.

Example SQL Query

CODE

select count(*) from [driverDB].[dbo].[Drivers]

Data Table

Data table data panels are designed to display a table of data to users.

Example SQL Query

CODE

SELECT TOP (25) 
    [Drivers].[Name] AS 'DriverName',
    [Drivers].[State],
    [Drivers].[Organisation],
    [FastestResult].[Car],
    [FastestResult].[TotalTime] as time(2)) as nvarchar) AS 'TotalTime',
    (Select count(*) from results where Driver = FastestResult.Driver) as #,
    [FastestResult].[DateTime] AS 'RaceTime'
FROM DriversFastestTimes as FastestResult
INNER JOIN [rimpa].[dbo].[Drivers] ON Drivers.ID = FastestResult.Driver
ORDER BY TotalTime

Spacer

A spacer data panel is an invisible element that consumes space that can be used to help position other data panels.

Chart

A chart data panel is designed to display a table of data in a selected chart type.

Chart Types

You can select the way the chart will display. The current options are Bar chart, Line chart and Pie chart

They may need specific values in specific orders to correctly render.

Bar

Below is an example of the SQL query and how that will render in a bar chart.

CODE

SELECT Job, Hours
FROM sampleNumeric

Example SQL Output

	Job	Hours
1	Design	5
2	Construction	12
3	Printing	6
4	Procurement	9
5	Procurement	4
6	Sales	2
7	Construction	6
8	Design	4
9	Procurement	9
10	Printing	12
11	Construction	2
12	Sales	2
13	Sales	3
14	Design	7
15	Construction	8
16	Sales	4
17	Sales	2
18	Design	4
19	Construction	8
20	Construction	8

Line

Below is an example of the SQL query and how that will render in a line chart.

CODE

SELECT FORMAT([Date],'dd/MM/yyyy')  as Date, SUM(Hours) AS Hours
FROM sampleNumeric
GROUP BY Date

Example SQL Output

	Job	Hours
1	07/01/2021	9
2	10/01/2021	5
3	12/01/2021	12
4	14/01/2021	6
5	01/02/2021	6
6	03/02/2021	6
7	05/02/2021	4
8	06/02/2021	23
9	07/02/2021	2
10	10/02/2021	10
11	12/02/2021	8
12	13/02/2021	4
13	14/02/2021	2
14	15/02/2021	4
15	16/02/2021	8
16	17/02/2021	8

Pie

CODE

SELECT Job, SUM(Hours) AS Hours
FROM sampleNumeric
GROUP BY Job

Example SQL Output

	Job	Hours
1	Construction	44
2	Design	20
3	Printing	18
4	Procurement	22
5	Sales	13