Hi everyone,
I have a heatmap, which shows the bonus of sales reps . In the y-axis i have sales, in x-axis the margin and the % of potential bonus is shown as a measure.
As a second measure, I added the current bonus of each sales rep. The idea of the app is to select a sales rep through a filter, the matrix is plotted and the current bonus is highlighted.
Even if I have the current bonus as a second measure, this is not shown at all in the heatmap. Does anyone know how to plot it? Or if this is even possible?
Here is how my data is structured (example of Matrix of 3x3 for 1 sales rep):
Sales Rep ID, x_axis_value, x_axis, y_axis_value, y_axis, %_bonus_possible, %_current_bonus
1001, 5.000, x_1, 30.0%, y_1, 0%, 3%
1001, 5.500, x_1, 35%, y_2, 3%, 3%
1001, 5.500, x_1, 37%, y_2, 5%, 3%
1001, 5.700, x_2, 30%, y_1, 3%, 3%
1001, 5.700, x_2, 35%, y_2, 5%, 3%
1001, 5.700, x_2, 37%, y_3, 7%, 3%
1001, 6.000, x_3, 30.0%, y_1, 3%, 3%
1001, 6.000, x_3, 35%, y_2, 5%, 3%
1001, 6.000, x_3, 37%, y_3, 7%, 3%
What i need is to plot the last field (%_current_bonus) in the heatmap together with the other values. At the moment, y_axis_value and x_axis_value are used as dimensions and avg(%_bonus_possible) is used as measure in the heatmap,
Any help is highly appreciated!
Thanks a lot in advance