If condition

[#1]

I have Date field in the table

I did some calculation like weekstart(Date) as call_week

now I need to show ' W1' in the place of 1-oct-2015  next 'W2' in the place of 14-oct-2015

[swuehl]

Maybe like

....

NewTable:

LOAD *,

          'W' & Autonumber(call_week,'WeekNum') as WeekNum

RESIDENT YourTable

ORDER BY call_week ASC;

DROP TABLE YourTable;

[prashantbaste]

Hi Naveen,

You can try 'Ceil (datefieldname / 7)' as Weeknumber and use this 'Weeknumber' field in your charts.

Hope this will be helpful.