Skip to Content
0
Former Member
Sep 11, 2013 at 11:40 AM

Is column chart with a variable x-axis possible in WEBI

56 Views

Hi All,

We have a requirement where there is a measure along both the x-axis and y-axis. Say, Employee count and Employee Salary are measures. The Dimension is department,

Department Employee Count Employee Salary 1 100 1000 2 200 2000 3 300 3000 4 400 4000

What is required is a chart where,

Employee Count should be on the y-axis. Employee salary should be on the x-axis and the Department will be in the z-axis or region colors will be by Region.

The X-axis needs to be continuos, that is the employee salary for department 1 being 1000, the employee salary for Department 2 should start after 1000 till 3000, for department 3 from 3000 to 6000. For department 4 from 6000 to 1000. The bar width should depcit the employee salary and the bar height show the Employee Count.

Thanks!