Sort by date

[former_member221192]

Hi Expert,

I have created line chart using two object (Count,Week)

Y Axis=Count

X Axis=Weeks (Format - MM/DD/YY)

I want take count of the last 8 week I did this one but X axis date was not coming as order as expected.Find the below images date is not displaying as order. Coud you please assist

here I want to display Date as sorted order like below format

2/22/16 - 2/28/2016

2/29/16 - 3/6/16

3/7/16   - 3/13/16

3/14/16 - 3/20/16

3/21/16 - 3/27/16

3/28/16 - 4/3/16

4/4/16   - 4/10/16

4/11/16  - 4/17/16

How to do?.Date contains MM/DD/YY format

Regards

Ganapathy

[Former Member]

Hi,

Amit solution will work if you still face problem you can try writing change the sql in universe for that date object.

Edit object -> Properties -> click on EDIt -> click on SQL button -> change the sql

order by date object asc

Enable "Do not generate sql before running"

Then click save and close

Then save the universe and export and check it will work

Regards,

Ragoth.C

[amitrathi239]

turn your chart to table.Add one more date object which you have used in the week variable calculation.Right click on date object->sort->ascending.

After sorting right click on column->hide.check if data is coming as sorted then turn to chart.

[former_member221192]

Hi Amit,

date value is displaying ascending order when table format but if change this table to chart

it is not displaying as ascending order .Find below screen highlighted in red color .