How to create PA report for open cases which are active in past date(Now Closed) for last 2 years?

[vinodh_2111]

How to create PA report for open cases which are active in past date(Now Closed) for last 2 years?

I tried collecting historic data but it is collecting same scores for every day.
Please help to achieve this requirement.
Thanks in advance.

[AndersBGS]

Hi @vinodh_2111 ,

You can't do this historically due to you have not collect any data on the state etc. Instead, I would recommend you to create the data collection, indicator source and automated indicator together with an automated breakdown by state, as then you will ensure to have the data going forward. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[AndersBGS]

Hi @vinodh_2111 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[vinodh_2111]

Hi @AndersBGS ,

Can I use Metric table in Indicator source. so that I may capture active tickets in the past.

[AndersBGS · Accepted solution]

Hi @vinodh_2111 

Yep - not a problem:

But again, the question is if you have data that has been captured earlier. If Metric instance table hold all the data already, then there is no problem at all.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders