I would like to know if you currently support the ability to show columns in a Dataset Column chart, even when the current value for one or more of those columns is zero. It appears that in these cases the column is simply removed from the chart, which makes the chart change all the time and is undesirable.
Specifically, lets say there are four ticket states we want to show for our ticket system (and for a variety of reasons too long to go into here we dont want to use an existing connector). Since the widget updates every three minutes, we want to show a column for each of “New”, “Open”, “Pending” and “Hold” tickets - even when one of those categories become zero for a period of time as tickets change state. This way there are always four column spaces, and each column changes as tickets are processed.
Further to this, it would be good to be able to set the order of the required columns - currently the ordering is done by default alphabetically, meaning we need to call the states “1New”, “2Open”, etc (or a variant of) so that the columns always appear in the same expected position from left to right.
If this is not possible currently, can we please look to add it? An option in the widget that would allow you to set the columns to show, and the order to show them in, even if there is no value in the dataset for the aggregation of that specific value.