Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Check the attached application solution and do modifications accordingly in your script or code.
Regards,
Ravikumar