Use average rating in Canvas Report for Calculated Column

[nabilasyarafina]

Hi SAP Community,

Our client requested to get an average of performance rating from each subarea.

We managed to get that average rating using canvas report as below.

	Subarea A	Subarea B
Average Rating	3.01550387596899	3.01360544217687

But, our client needs more information from the average rating, where every subarea has specific range to determine whether if it’s higher, lower or within the range.

For example,:

Subarea A has range 3.6 – 3.99

If Subarea A’s average rating is within the range, there’s a field that describes it as “OK” / “Within the range”

If Subarea A’s average rating is below the range, there’s a field that describes it as “LOWER”

If Subarea A’s average rating is above the range, there’s a field that describes it as “HIGHER”

We’ve tried using Calculated Column, but since the report checked it based on each employee, it doesn’t suit our client needs.

Is it possible to create this report with Canvas or probably Story?

Thank you.