I've got a pretty simple need for a graph, or at least I thought it was.
We have a number of time based products and I'd like to have a chart that goes:
<1 Hour 45 Mins 30 mins 15min OnTime
But not all products have files arriving in every timeframe, so may appear as:
45mins 15mins
As you can imaging this makes reporting for management impossible.
I have tried two methods:
1) Nested select where I set each of the required fields and does a count, therefore every result shows all five values, but I cannot figure out how so make a chart work from these values
2) Using case - this was I can do a create a timeval field with the values "! Hour", "45 ins" etc etc, but that is where I end up with some of these values not appeaing, so don;t get the full chart.
Any ideas as I've been going round in circles for days now!!
Oh, we're using SQL 2005.