Error in Pega Insights with dual average value calculation

General
, , , , , , , ,
1

If we add two average values together to any insights the values are calculated incorrectly.

  1. Add interaction time to insights and configure it to display as average as part of measurement ( InteractionTime Final rule - decimal)
  2. Add focus time to insights and configure it to display as average as part of measurement (FocusTime OOTB rule - integer)
  3. Along dimensions add some value such as channel
    Output :
    The average values for interaction time and focus time is incorrect
    Expected Output :
    The average values for interaction time and focus time should be correctPlease note : If we add only one average value in measurements, the value is correct. On adding two values the calculations are completely incorrect.
2

This is a Pega product issue - workaround is that in the report definition that you are using to pull data from, then in Data access tab go to Data retrieval preference and change from Use search data to Use database. In this case, Pega will start pulling the data from RDBMS instead of SRS. The bug lies with SRS system of retrieval.