Skip to Content
0
Former Member
Jan 29, 2009 at 01:14 AM

Sort the data weekly

21 Views

Hi,

I need to get the ticket data for the last 6 months and then sort them by week and then by the Product ID. The date field is in epoch format. Whats the best way to do it?

Do I need to create a formula on date field and then group on it?

Example:

Week 10/12/2008

IPW - 25

EPA - 37

WER - 14

Week 10/19/2008

IPW - 22

EPA - 29

WER - 13

Week 10/26/2008

..

..

and so on

Regards,

Vamshi