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!!