I have a table (attached as a screenshot) where each employee in a company is associated with an identifier, the department they belong to, their performance (a numerical value between 0 and 100), and their potential to take on new responsibilities (a numerical value between 0 and 1). I would like to create a chart that shows the distribution of employees in the commercial department (Count({<Departament={commercial }>}ID)) based on their potential to take on new responsibilities (vertical axis, Y) and their performance (horizontal axis, X). Specifically, after defining these two axes, the chart should display how many employees fall into the range of 0–10 (performance) and 0–0.1 (potential), then the number of employees in the range of 10–20 (performance) and 0.1–0.2 (potential), and so on. It would be a kind of matrix, where each matrix cell of the dimesion 10 X 0.1 (performance X potential) contains the number of employees from the commercial department. I’m not sure which chart type would work best to achieve this. Any help would be greatly appreciated.
