Forum Discussion
Dynamic compensation midpoint line on x-axis
I have a table of data based on Time In Position (TIP) and Total Base Pay Amount. We look at groups of individuals in each position in our company, and I need to visually see who falls at the midpoint and under the minimum point of our salary ranges for each position.
Is there a way to add in a dynamic line on the x-axis showing min and mid points? I tried the x-axis constant and Percentiles methods in Analytics under Visualizations, and that's not what I need.
Below is an example of the data I already have. I just need to add some dynamic lines for the data.
5 Replies
- parry2k
Super User
Anonymous you can use measure to show min/max line on analytic tab
parry2k We tried the min/max lines on the analytic tab, but that shows us a line for the minimum point of data instead of the minimum of our range (the two are separate columns). Ideally, every point of data would be above our minimum of the pay range, as we strive to pay above the minimum of a pay range.
- parry2k
Anonymous doesn't matter if these are two different column, as far as your measure is returing the correct value it should work, try to check the value of your MEASURE wiht some other visual like table visual to see you are getting correct values.
