Is it possible to group by months in Performance Analytics

[tyagisu]

Hi,

I have been trying to show the report in PA which can display my assignment group in rows and months in a column. I could have used normal reporting trend but the result of these rows and column cannot be calculated without PA.

The result would be in % and formula I used is:

% of Successful Changes = [[Number of successful changes monthly]] / [[Number of closed changes monthly]] * 100

I have used formula indicator for this calculation. Number of successful changes monthly and Number of closed changes monthly are automated indicators I created. There is a monthly change job running for these indicators.

I want to see something like this:

This is what I am getting, just 1 month in column.

Any help would be appreciated. Thanks in advance.

[dangrady510 · Accepted solution]

If you edit your breakdown widget you will see a related list called column settings.  One of the check box options is Multiple Scores.

Once you select that option you will be able to choose the number of periods as well as the steps.  These settings will align to the Time Series setting for the widget.  So in your case if you choose 3 periods you will see 3 months columns, one for each of the last 3 months.

[tyagisu]

Thanks for your quick reply... This is exactly what I want to see. Perfect!

~Su