Min, Max, Current - help with a bar chart

[andyquirin]

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

[MK_QSL]

Create a Cyclic Group for

     Ticket Closed Per employee by location

     Ticket Closed per employee by shift

and use it as a single dimension for bar chart

Expression

MIN(Aggr(SUM(TICKET),Employee))

MAX(Aggr(SUM(TICKET),Employee))

SUM(Aggr(SUM(TICKET),Employee))