Sort Order In Cyclic Group

[Muthu]

Hi,

I am creating a chart with the cyclic group as dimension.

I have values like year month and week as the fields in the Cyclic Group,

I am selecting a filter in the calender range, august 2014 - March - 2015,

In the chart when I select the year its giving me correct values starting from August -2014,

as I have given condition in  the group sort order ( Year & num(Month,00)),

I Tried giving the same kind of sort order expression for week, But its not giving the correct values,

Please help.

Muthu

[jpenuliar]

Have you tried setting the Sort options in Group Settings?

[jpenuliar]

Your Week is probably tagged as $Text in your Data Model, whereas the other Calendar fields are tagged $Numeric and you are sorting Week as Numeric

[Muthu]

Hi Jonathan,

I tried doing that.

It didn't work

[sunny_talwar]

What is your exact script for creating the week field?

[Muthu]

Hi,

I have used Week(DateField)

[jpenuliar]

And What are the Sort options you selected for this Field?

[sunny_talwar]

Have you tried using Load order for sorting?

[Muthu]

I tried giving expression and ascending order

[Muthu]

I gave ascending order and the expression