Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.