I have a report with two summary groups that roll up into a graph. The graph shows total tickets open per group and breaks down each bar in groups as to how long the tickets have been open in days.
I want to change the order of how the groups are currently displaying. i.e. - Tickets open "0 to 5", "6 to 10", ...
If there is not a simple way, can I hard code an order by using SQL?
Example:
-----------------------
1| 2| 1| 4|8 My attempt at a bar.
-----------------------
1 ticket open "6 to 10" days
2 tickets open "0 to 5"days
1 ticket open "11 to 20" days
4 tickets open "31 & up" days
Obviously I would want the above to be sorted sequentially.
Any suggestions would be greatly appreciated.
Jeff
I want to change the order of how the groups are currently displaying. i.e. - Tickets open "0 to 5", "6 to 10", ...
If there is not a simple way, can I hard code an order by using SQL?
Example:
-----------------------
1| 2| 1| 4|8 My attempt at a bar.
-----------------------
1 ticket open "6 to 10" days
2 tickets open "0 to 5"days
1 ticket open "11 to 20" days
4 tickets open "31 & up" days
Obviously I would want the above to be sorted sequentially.
Any suggestions would be greatly appreciated.
Jeff