Performance Analytics open and close demands

[Leonel Sandroni]

Hi there!

I'm trying to build a PA indicator which shows two different trends:

1-Open demands everyday

2-The same for close demands

 

The requirement is count demands created for every day and it shouldn't add up them day after day. For the moment, I just got build it for the last one that I said (sum not count).

The indicator filters:

Source indicator:

Do you have any suggestion?

thanks!

[AndersBGS]

Hi @Leonel Sandroni ,

First of all, do you want to capture historical data or only data going forward on daily basis? Where do you have issues in your current build?

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

best regards

Anders

[Leonel Sandroni]

Hi @AndersBGS

I want to build a historical trend where each point of this trend should count only the open demands on each corresponding day. For example, if you opened 3 demands on Monday, 4 yesterday and 2 today, the trend should show you 3-4-2.  At the moment, I only got to build a trend that adds up the open demands, and it shows 3-7-9.

I don't know how to configure the filter conditions in order to accomplish this requirement. I have tried with "created" and "open" fields and it's not working.

[AndersBGS · Accepted solution]

Hi @Leonel Sandroni ,

The reason that you're experience issues is, that you have no exact time stamp for open records. This refer to, if you run a historical data collection it will collect that you had 3 open monday, 7 yesterday and 9 open today. 

Basic, you should only run historical data collection on fixed date fields. E.g. Open on, created on, resolved on etc.

Going forward, you can create a daily, weekly etc. data collection with condition state is open etc.

Please note, that you should select the daily, weekly, monthly data collection as a summarized value from indicator level will give wrong information. 

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

best regards

Anders

[Leonel Sandroni]

Ok, I understand! It seems it's not possible to build exactly what I want. Anyway, thanks for your help!!