I'm creating a percent bar graph to graph how long it takes a buyer to answer invoice cost messages. I created a formula to categorize the number of days as follows:
0 days
1-7 days
8-14 days
15-21 days
22-28 days
29+ days
In the graph each aging category is stacked on each other for a rolling 12 months and I've sorted the categories so that 0 days is on the bottom and 29+ days is on top. The problem is that if a buyer doesn't have any data in the 0 days category in the first bar (month 1), each successive bar will start with the next category even if that month had 0 days data. Below is the graph.
How can I force the sort order even if not every month contains data in each category.
IP Logged
