Empty value first

[#1]

Hi,

Is there a way to sort the chart values so that the empty value would be the first value starting from the left?

Thanks in advance

[giakoum]

Most likely yes, if you can post a sample app that would be helpful

But I would either get rid of the null value or label it

[marcus_sommer]

I'm not sure what do you mean with empty values - values from days which are a sunday? Maybe something like this:

if(num(weekday(date))=6, 1, avg(date)) // as sorting-expression

- Marcus

[swuehl]

I assume you are talking about the rightmost bar, with no dimension value assigned.

I don't think you can show this at leftmost position unless you create a Date dimension value for these records.