problem with null values in bar chart
540447Dec 3 2006 — edited Dec 6 2006Hi,
I have a simple vertical bar chart represent duration or some counting value by date.
in the past I encounter a problem when i worked on a stacked ber chart, where there are some null/0 values. so i had to add UNION ALL statement.
Is it make sense that the problem exist in this simple chart too??? when all my values are 0's the chart doesn't present anything, while when some (even 1) of the values isn't 0, it present all the values (include the rest of 0's).
why doesn't it present this kind of situation? would UNION ALL help here too?
appreciate your help
Liron