Forum Discussion

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi Anonymous,

 

It seems that you may need to unpivot the columns  Satisfaction Bronze, Satisfaction Silver, Satisfaction Gold to be one column first, then create the realtionship of the two tables.

 

Besides, I 'm a little confused that the logic of your output.

 

 

86% = Satisfaction Bronze

90% = Satisfaction Silver

94% = Satisfaction Gold

 

So for instance an output would be:


 

The satisfaction % of Timothy Witten is 89.99%, and the output show that Satisfaction Level is Satisfaction Bronze which matched 86%. So could you describe your condition  about the level in more details, so that we can help further investigate on it?

 

Best Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    v-piga-msft Yes, it's supposed to be a range. So 86%-89.99% would classify a person as having Satisfaction Bronze. Once he hits 90% flat he will then be in the Satisfaction Silver category which would then change the amount of bonus he would earn.