This discussion is archived
2 Replies Latest reply: Oct 22, 2012 5:03 AM by user544069 RSS

Displaying range of weeks dynamically

user544069 Newbie
Currently Being Moderated
I have a report in my dashboard which displays progress for different projects for every week.

Requirement is like . I need to display range of weeeks like Previous 4 weeks, current weeks and next 4 weeks
when i Open the dashboard.

I also need Week No Prompt which will override the week range.


Challenge is that. Each project will have different current week. Based on the project the user select in the prompt
we need to get the current week and display the week range. and Week No prompt should be able to override it..

any way to achieve this

Edited by: 966489 on Oct 19, 2012 2:17 AM
  • 1. Re: Displaying range of weeks dynamically
    Srini VEERAVALLI Guru
    Currently Being Moderated
    I would suggest to pick column Week and the date columns in the prompt and set date as contraint to week.
    For date column use expression min(date) and set Presentation variable as D
    In the report get the date and use filter between as below
    ast(Time.Date as date) between date '@{D}{2010-01-01}' and TimeStampAdd(SQL_TSI_WEEK,4,date '@{D}{2010-01-01}')

    This would show the 4 weeks, and the rest do changes as per you requirements

    Any issues let me know, if helps pls mark as correct
  • 2. Re: Displaying range of weeks dynamically
    user544069 Newbie
    Currently Being Moderated
    I dont have calender week or financial week.. Its project week week number for each project will varry..

    Based on the project we select in the prompt the corresponding current week, Previous 4 weeks and next 4 weeks needs to be displayed

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points