Sort Chart not working

[ivandrago]

Hi,

I have the attached Document, I have a issue with the Sortkey not putting the correct numbers, I want it to be like the below

DateMonth, SortKey

01-JUN-2015, 1

01-JUL-2015, 2

01-AUG-2015, 3

01-SEP-2015, 4

01-OCT-2015, 5

01-NOV-2015, 6

Also what format does the SortKey need to be for it to work in the Expression?   .

Thanks

[MK_QSL · Accepted solution]

You can sort it without the additional table.. i.e. sort key. Check enclosed file..

[maxgro]

Fact:

LOAD ID, Date(Date#(DateMonth, 'DD-MMM-YYYY'), 'DD-MMM-YYYY') as DateMonth, Amount, Manufacturer, Type, Ver, Pick

INLINE [

    ID, DateMonth, Amount, Manufacturer, Type, Ver, Pick

    1, 01-JUN-2015, 500, B, OFF, LIVE, JS,

     .......................

    18, 01-NOV-2015, 300, B, ON, LIVE, JT

];

Concatenate

LOAD ID, Date(Date#(DateMonth, 'DD-MMM-YYYY'), 'DD-MMM-YYYY') as DateMonth, Amount, Manufacturer, Type, Ver, Pick  INLINE [

  ID, DateMonth, Amount, Manufacturer, Type, Ver, Pick

    1, 01-JUN-2015, 500, B, OFF, ARCHIVE, JS,

    ..................

    18, 01-NOV-2015, 300, B, ON, ARCHIVE, JT

];