Performance Analytics is not breaking down the data by month, or week

[Greg Wilk]

I created a formula indicator to show the % of successful searches in our KB environment.  The formula we used is [[Total Results]]/[[Total Searches]]*100.  The answer we get is 80%.  This is correct.  However when I choose sort by month AVG+, it shows 80% across each month as the value for June, July and August.  However those values for each of those months should be 76%, 78% and 86% respectively.   Any help is appreciated so I can view the correct value for each month.  TY.

[Mohith Devatte · Accepted solution]

Hello @Greg Wilk ,

You need to apply a date filter in the indicator source for this 

1) Lets say you are getting data from incident table in indicator source and frequency is monthly 

2) Then in the first  automated indicator you get the closed incidents 

3) Then in second you get count of all incidents

4) and then in formula indicator you apply the formula to get  percentage of closed incidents per month .

this will also show same percentage because we did not tell the system to pick up every months data individually in the filter

So in the indicator source if you put "CREATED ON THIS MONTH" then it will show different percentages 

Same way please open you indicator source and then add this filter "CREATED ON THIS MONTH"

then run the PA job and see the result 

Hope this helps 

PLEASE MARK MY ANSWER CORRECT IF THIS HELPS YOU

[geethajammu]

Hi Mohith, 

Even i have same issue need to show data incidents not resolved or closed on monthly basis. Have set condition as created on this month and frequency is monthly. So data is showing correct for nov month but if i filter for oct then it is showing previous 3 months data. 

Would you please help me out .

Regards,

Geetha.

[Greg Wilk]

This was exactly what I needed!  Thanks for the explanation!