Data Panel Dashboard (DPD)
Data Panels
Single Value
Single value data panels are designed to display a single value to users.
Example SQL Query
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
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.
SELECT Job, Hours
FROM sampleNumeric
Line
Below is an example of the SQL query and how that will render in a line chart.
SELECT FORMAT([Date],'dd/MM/yyyy') as Date, SUM(Hours) AS Hours
FROM sampleNumeric
GROUP BY Date
Pie
SELECT Job, SUM(Hours) AS Hours
FROM sampleNumeric
GROUP BY Job