Week

[NavinReddy]

Hi Community,

I have Week table

How should i find out date start from Sundays-Saturday

could some one help me

Thanks in Advance

rohith

[kaushiknsolanki]

Hi,

     You can create a flag in script which will number the days starting from Sunday to Saturday.

     Below code will help you to create a flag

Let vMin = num(MakeDate(2012,01,01));
Let vMax = num(MakeDate(2012,12,21));

Load Date($(vMin) + RowNo() -1) as DATE,
  WeekDay(Date($(vMin) + RowNo() -1)) as WEEKDAY,
  if(num(WeekDay(Date($(vMin) + RowNo() -1)))=6,1,NUm(WeekDay(Date($(vMin) + RowNo() -1)))+2) as WEEK_NUM
AutoGenerate 1
while Date($(vMin) + RowNo() -1) < Date($(vMax));

Regards,

Kaushik Solanki

[NavinReddy]

Hi kaushik,

No need to be display every thing

Latest week should only i need to be disyplay

Thanks

Rohith

[kaushiknsolanki]

Hi,

     Sorry I didnt got what you mean by everything,

Regards,

Kaushik Solanki

[NavinReddy]

Hi,

From that table i need to be display last week of data(Sunday-Saturday)

Thanks,

rohith

[kaushiknsolanki]

Hi,

     Do you mean to say that you only want to show the Sunday and Saturday's Date and its relevant data?

Regards,

Kaushik Solanki

[NavinReddy]

Yes,exactly kaushik

Previous Week (Mar 7, 2013 - Mar 14, 2013) format

[kaushiknsolanki]

So,

     If you mean you want to show only the last week data in chart then use the following set analysis.

     Sum({<Date = {">=$(=Date(WeekStart(Today())-7)<=$(=date(weekend(today())-7))"},Month=Year=,Week=>}Sales)

     If you dont want that data at all in the application, you can filter the same way when you are loading the data.

Regards,

Kaushik Solanki

[NavinReddy]

Thank you Kaushik

[NavinReddy]

Hi kaushik,

i have two expressions ,these are in right side of chart

How can i set these expression in buttom of the chart

thanks,

rohith