A calculation is not correct in VInsights Average Calls Per Day Report in CRM Online.
End-users record almost the same numbers of calls every day each month. However, there is an obvious drop in only one month on the report.
The calculation logic is the same for each month. However, there is a data issue for the month. Since ActivitySync does not run to success one day, the Number of Calls Made in the month is not correct. Thus, the Average Calls Per Day Calculation is reduced for that month.
To fix this issue, the user can enforce a FullSync by setting the value of Last_Successful_Sync_vod_c to a date that is more than 15 days earlier than the current date in Veeva_Analytics_Process_vod_c.
For example, the current Last_Successful_Sync_vod_c is '2018-08-16'.
- Set this value to 2018-08-01.
- Run the ActivitySync process.
CRM Online Help: Call Activity Data Loading Process
Send us your feedback: We are always looking for feedback to help improve our Knowledge Base! Please let us know if this article is helpful or provide feedback on how we can improve your experience by clicking here.