Using the ones you've linked I was able to figure out the data population so that has been a massive help. Linked is what I am trying to go for within the reports. The image is something I have running in the UMP as a dashboard, but I'd like to make it a static report as it runs a lot of SQL in the background. The following SQL is used to collect the data:
SELECT
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 1
Group by c.period_begin) as '1',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 2
Group by c.period_begin) as '2',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 3
Group by c.period_begin) as '3',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 4
Group by c.period_begin) as '4',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 5
Group by c.period_begin) as '5',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 6
Group by c.period_begin) as '6',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 7
Group by c.period_begin) as '7',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 8
Group by c.period_begin) as '8',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 9
Group by c.period_begin) as '9',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 10
Group by c.period_begin) as '10',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 11
Group by c.period_begin) as '11',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 12
Group by c.period_begin) as '12',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 13
Group by c.period_begin) as '13',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 14
Group by c.period_begin) as '14',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 15
Group by c.period_begin) as '15',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 16
Group by c.period_begin) as '16',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 17
Group by c.period_begin) as '17',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 18
Group by c.period_begin) as '18',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 19
Group by c.period_begin) as '19',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 20
Group by c.period_begin) as '20',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 21
Group by c.period_begin) as '21',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 22
Group by c.period_begin) as '22',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 23
Group by c.period_begin) as '23',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 24
Group by c.period_begin) as '24',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 25
Group by c.period_begin) as '25',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 26
Group by c.period_begin) as '26',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 27
Group by c.period_begin) as '27',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 28
Group by c.period_begin) as '28',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 29
Group by c.period_begin) as '29',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 30
Group by c.period_begin) as '30',
(select CAST(ROUND(AVG(c.percentage),2,1) as Decimal (18,2))
from S_SLO_DEFINITION d, H_SLO_COMPLIANCE c
where d.slo_id = c.slo_id
and d.slo_id = 835
and (MONTH(c.period_begin) = MONTH(GETDATE())-1) AND (YEAR(c.period_begin) = YEAR(GETDATE()))
and DAY(c.period_begin) = 31
Group by c.period_begin) as '31'
We have a lot of these that run on a single page. Right now I'm just trying to find the best way to make a similar view in the iReporter.