Sort issue in bar chart

[#1]

Hi,

I have an issue in a bar chart where as Dimension I have : week(Date) and 3 expressions

Opened Cases : count(Distinct if(DateType='Open', CaseNumber))

Closed Cases : count(Distinct {$<DateType={'Closed'}>}  CaseNumber)

Remaining : count(Distinct if(DateType='Open', CaseNumber)) - count(Distinct {$<DateType={'Closed'}>}  CaseNumber)  (!Here I use Full Accumulation)

And in the sort tab I have :

Sorting by Week : State = 'Ascending' and Numeric Value = 'Ascending'

The selection I make is in a RangeDate by DateType='Open', from 01/09/2015 to 12/01/2016.

My goal is to have Week1 and Week2 at the end, because Week1 and Week2 are from January 2016, after 2015.

(Check the attached file)

Can you give me any idea how can I resolve this ? Or any work arounds ?

If you need any information, tell me.

Thank you!

[swuehl]

Try sorting by expression

=Max(Date)

ascending.

[Anonymous · Accepted solution]

How about creating a composite field of Year & Week to have values like :

     2015|52

     2016|01

Then if you sort against this you data should end up in the order your require.

[hemhund2016]

You could sort the Week as expression in ascending order using below.

Year(Date)&Week(Date)

[MK_QSL]

Like this?

[Gabriel]

Hi,

In your Sort tab, use Expression and have Year in the expression and sort ASC

[#7]

Thank you very much ! It worked.