Back log for Open cases

[#1]

I have a requirement where if user selects year then he need to see the data for max week of that year and if he selects quarter he should see max week data of that quarter and if he selects month then he need to see max week of that month and if he selects week he need to see particular week data.

Year data is 2014

quarter data is 2014-Q1,2014-Q2 and

month data will be 2014-01,2014-02... and

week data will be 2014-W01,2014-W02 ...2014-W52.

for ex: in 2014  my last load date is 16/09/2014 then if he selects year he needs to see this load data as of 16/09/2014.

                if he selects 2014-Q1 then he needs to see data for last week of march load date data.

                if he selects month 2014-05 then he needs to see data for last week for that month.

could you please help me on this

[marcus_sommer]

You could use a searchstring to select the week or an expression which ignored all further weeks:

search-string: week = week(max(date))

expression: sum({< week = {"$(=week(max(date)))"}>} ANYFIELD)

- Marcus

[#3]

Hi,

Check the attached application solution and do modifications accordingly in your script or code.

Regards,

Ravikumar