Hello All,
Is there a way to import the date from pa_scores_l1 data from prod instance to uat instance for a specific indicator over last three period to show the trend (score)?
In UAT, I have records for last 3 months, but the requirement is to match the data with prod, since the indicator source doesn't have a date/time condition defined, we cannot re-run the historic job to get the exact count for the respective period as this will update the latest record for all 3 months. So, I deleted the current scores from pa_scores_l1 table for a specific month and imported the score (records in pa_scores_l1) from production instance. But still not showing the trend (score) for the data which I imported. it shows null all over.
Is there some way to show the score based on imported data on the pa_scores_l1?
