1 Reply Latest reply: Jan 10, 2014 5:13 PM by Manish Kachhia RSS

    Min, Max, Current - help with a bar chart

    Andrew Quirin

      Hey Qlik'ers,

       

      I need some help with a bar chart and hopefully you guys will know what to do.

      I'm making a 'headcount' dashboard used for workforce planning that has 12 months of data in it.

      It needs to have a single bar chart that shows Minimum, Maximum, and Current number of tickets closed per employee.

      I will need to show this by a few different dimensions (tickets closed per employee by shift, tickets closed per employee by location, etc). Is there a good way to do this without coding out the min/max/current on the SQL side?

       

      Thanks in advance for your help!!

       

      Andy