How to increase granularity of 95percentile report?

brunofl

Considering this report:

DECLARE @StartDate DateTime
        DECLARE @EndDate DateTime

        SET @StartDate = ${FromTime}
        SET @EndDate = ${ToTime}

        SELECT	Interfaces.InterfaceId,
        Nodes.NodeID,
        Nodes.Caption AS NodeName,
        Interfaces.Caption AS Interface_Caption,
        Maxbps_In90,
        Maxbps_Out90,
        Maxbps_In95,
        Maxbps_Out95,
        Maxbps_In99,
        Maxbps_Out99
        FROM Nodes
        INNER JOIN Interfaces ON Nodes.NodeID = Interfaces.NodeID
        INNER JOIN (
        SELECT InterfaceID,
        dbo.GetInBpsPercentile(InterfaceID, @StartDate, @EndDate,90) AS Maxbps_In90,
        dbo.GetOutBpsPercentile(InterfaceID, @StartDate, @EndDate,90) AS Maxbps_Out90,
        dbo.GetInBpsPercentile(InterfaceID, @StartDate, @EndDate,95) AS Maxbps_In95,
        dbo.GetOutBpsPercentile(InterfaceID, @StartDate, @EndDate,95) AS Maxbps_Out95,
        dbo.GetInBpsPercentile(InterfaceID, @StartDate, @EndDate,99) AS Maxbps_In99,
        dbo.GetOutBpsPercentile(InterfaceID, @StartDate, @EndDate,99) AS Maxbps_Out99
        FROM InterfaceTraffic
        WHERE InterfaceTraffic.DateTime >= @StartDate AND InterfaceTraffic.DateTime <= @EndDate
        GROUP BY InterfaceID
        ) TrafficStat
        ON Interfaces.InterfaceID = TrafficStat.InterfaceID

I have 90 days of data updated every 5 min and I would like to get the 95 percentile for a window of every 6 or 8 hours of data .
How can I make this happen? SQL version is 2016.
Any help will be very welcome.
Thanks!

deverts

If this is a Web-based report, you can change the data depicted to 2 hours, today, yesterday, etc. In the report, next to the data source, you will find the option to change the "From."

D