public async Task <IEnumerable <GraphStatDto> > Get(decimal period, Filters filters)
{
var httpStatusWhere = _testResultRepository.CreateWhereClause(filters, out var sqlParams);
var sql = $@"
SELECT
Minute,
COUNT(Id) as Requests,
COUNT(DISTINCT UserNumber) as Users,
AVG(ElapsedMilliseconds) as Avg,
MIN(ElapsedMilliseconds) as Min,
MAX(ElapsedMilliseconds) as Max,
SUM(ElapsedMilliseconds * ElapsedMilliseconds) / COUNT(Id) - AVG(ElapsedMilliseconds) * AVG(ElapsedMilliseconds) AS Variance
FROM
(
SELECT
*,
CAST(RequestStartedMs / {period} as int64) as Minute
FROM (
SELECT
HttpStatusResult.[IterationId] as Id
,SUM(HttpStatusResult.[ElapsedMilliseconds]) AS ElapsedMilliseconds
,MIN(HttpStatusResult.[RequestStartedMs]) AS [RequestStartedMs]
,TestName
,UserNumber
FROM HttpStatusResult
INNER JOIN Iteration ON Iteration.Id = HttpStatusResult.IterationId
{httpStatusWhere}
GROUP BY IterationId, TestName, UserNumber
) as testruns
) as t
group by t.Minute
order by Minute
";
var result = await _connection.QueryAsync <GraphStatDto>(sql, sqlParams);
return(result);
}