How to achieve a report that shows granular 5 min information without having to change the data coll (4249910)

When granularity 5 minutes is selected for FTR report on response time, duplicates data value is shown for 3 samples

Data Report Built on

This is due to default retention policy and 15 min rollup. The report shows same value for average, min and maximum value for the 15 min for every 5 min period.

Problematic Table

As the default rollup is 15 mins, the retention policy for the parent label or object “EURESULT” can be changed to 5 mins. i.e. Goto Foglight UI | Dashboards Navigation Pane | Data | Manage Retention Policies | Filter for “EU-Core” (This object is used, as the example is taken for FTR Report) | Look for “EURESULT” | Click on “EURESULT | Change the values and click Save.

Raw Data reflecting the change