I get the look, but what data are you trying to capture and display in the columns to the right?
Well, not yet know the exact gives an example to me of Generic?
Your best bet would be to use report writer wizard or custom SQL to get the data you want. It should be easy to format it like your picture. Then add the report as a resource to the view of your choice. a lot of our dashboards use elements of report resources to give us the view we desire.
Define a group for each one of the services and then use the daily group availability to display a status icon in each square.
Since we do not have group properties you may have to use a specific name pattern for your groups to select which ones get display in the status matrix.
Controlling membership of the group will determine what things 'down' change the percentage availability; this saves us having to do availability calculations and we only have to worry about displaying the ststus in a nicely formatted fashion.
Here is the basic SQL query to can use in a report:
SELECT C.name, C.containerid,
FROM containerstatus_daily CSD
INNER JOIN containers C
ON C.containerid = CSD.containerid
WHERE C.name LIKE 'U%'
AND CSD.datetime < Dateadd(day, -7, Getdate())
I leave the following as an exercise for the reader:
- pivoting the query (Using PIVOT and UNPIVOT)
- displaying icons to represent the percent availability CASE (Transact-SQL)
- linking to the group page where you could display a map showing the dependencies of the items that make service availability (report writer functionality)
Thank guys , I will try and speak here.