OTBI: Creating Performance Tiles based on Performance Document Rating Levels

Question

Hi,

We need to create Performance Tiles based on Rating Levels similar to the below

Unfortunately the Performance Tiles does not have much flexibility, it shows values based on pure measures. The workaround is to use Pivot Tables but the layout is not user friendly at all. I've tried to create measures on Subject Area: Workforce Performance - Performance Rating Real Time, but it is very time consuming and still facing issues to get the correct figures.

I've tried to add a new Measure like:

SUM(CASE WHEN "- Rating Level"."Rating Level Code" = 1 THEN (COUNT(DISTINCT "Worker"."Person Number") ) but he returned numbers are not correct.

Are there any much simpler way to achieve something similar.

RVohra · Answer

@Mr H, please explore creating four separate analyses, each filtered to a specific rating level, and place them side by side on the dashboard. Hope it helps!