Creating Trend Report Based On Historical Data From Another Report That Updates Weekly

manish kale
Tera Guru

‎08-05-2023 07:28 AM - edited ‎08-05-2023 07:29 AM

Hello all,

We have a requirement where we need to create a trend report based on the other report data that updates weekly.
Explanation: 
There is a score report that is generated by calling the script include in the report and gives a certain final score at the end of the week. Let's say we got a score of 27. That is the final count till Friday for this week and the count will start over again in the next week and will give another final count. So we want to track the final score over a weekly time period in another report as a trend report. 

Please let me what should be the appropriate steps. I appreciate your help in advance.

Best Regards,
Manish kale

0 Helpfuls
  • 359 Views
1 REPLY 1

Maik Skoddow
Tera Patron
Tera Patron

‎08-05-2023 08:05 AM - edited ‎08-05-2023 08:06 AM

Hi

what you want to achieve is exactly what Performance Analytics can provide to you. If you cannot use PA you have to rebuild the core concept by your own. That means you need a scheduled job which is calculating the score on a daily basis. That value has to be stored in a simple custom table which then can be the source for your overall report.