Sorting Week No in chart

[dsharmaqv]

Hi I am displaying weekly trade amount in line chart but unable to sort the week according to the dates.

for example

week 52 for yr 2016 should appear before the week 1 of yr 2017

Can ome one help me out with this

table:

Week_No	SURV_Date	Trade Amt
1	02 01 17	0.8
4	23 01 17	0.6
5	30 01 17	0.33
52	26 12 16	3.2
6	06 02 17	1.4
8	20 02 17	3.8
9	27 02 17	2.2

[sunny_talwar · Accepted solution]

May be use a calculated dimension

Dual(Week_No, WeekStart(SURV_Date))

[dsharmaqv]

Thanks Sunny

Also can you please help me in getting the latest week sales amt

in above case week no 9 has sales amt 2.2

[sunny_talwar]

May just this

Sum({<SURV_Date = {"=$(Max(SURV_Date))"}>}[Trade Amt])

[dsharmaqv]

I am trying to display latest value in text object but with above expression I am getting 0

[sunny_talwar]

My bad, I misplaced an equal sign

Sum({<SURV_Date = {"$(=Max(SURV_Date))"}>}[Trade Amt])

[dsharmaqv]

expression is summing up all the values

returning

12.33

can you please post the app.

[sunny_talwar]

I create a new field to do this

Table:

LOAD *,

  Num(Date#(SURV_Date, 'DD MM YY')) as DateNum;

LOAD * INLINE [

    Week_No, SURV_Date, Trade Amt

    1, 02 01 17, 0.8

    4, 23 01 17, 0.6

    5, 30 01 17, 0.33

    52, 26 12 16, 3.2

    6, 06 02 17, 1.4

    8, 20 02 17, 3.8

    9, 27 02 17, 2.2

];