2 Challenges with bar charts

[Anonymous]

Hi, I have a bar chart that can contain 3 "date buckets": <=1 Bus day, 2 days, >=3 Bus Days. They are linked to a table and act as a filter .
Two asks:

1. How do i sort them in the order that you see above? The legend details above are in one field

2. If the data set doesn't contain one or more of those values, they don't appear and of course the legend doesn't appear. Is there a way for me to force an entry into the legend if no records appear for any of the above, so it appears as 0 in the bar, and the description appears in the legend? Example of it missing, below:

I originally seperated out each as a column, and that worked great. It just didn't allow me to do drill down.
This is close to what the customer wants but they will also want the legend sorted with a descrption, and 0, if nothing appears.

[Anonymous]

Thanks, this did the trick (almost)
My final challenge to this is that I'm trying to sort the data in a specific order, I set the column

I'd like to get it in the order as it appears in the field DatabucketSort, and i did choose to sort by that field (in the column menu) but it is ignoring that request.

[KNP]

The DateBuckets field on your chart came from which table?

It needs to come from the DateBuckets table, not your fact table.

[Anonymous]

Thank you very much. This could work for me.

[KNP · Accepted solution]

A little difficult to give a definitive answer without actually seeing the data and data model but I put together a crude example. See attached.

The key to get the sorting to work is to have a sortable field to sort on and then choose the sort by option.

Having the buckets in a separate table to the data and choosing the 'Show items with no data' takes care of always showing the legend.