topic Re: I want to Add Max Year to My set Analysis in App Development

I want to Add Max Year to My set Analysis

jamiemcc — Wed, 22 Dec 2021 17:26:36 GMT

Hi Guys,

Coming into 2020 i Want to add in Max year to my Set analysis Function. At the Moment I only have 2019 data.

The Below Function gives me the Last 8 Weeks Of tasks. How do i add in Max year so when we step into 2020 It will display last 8 weeks Accordingly?

sum({<DailyTaskType = {'Counts'}, Week = {">=$(=Max(Week)-8)<$(=Max(Week))"}>}EstimatedTaskTime*Tasks)

Thanking You in Advance.

Re: I want to Add Max Year to My set Analysis

Anil_Babu_Samineni — Thu, 19 Dec 2019 11:58:48 GMT

Perhaps this

sum({<DailyTaskType = {'Counts'}, Year={"$(=Max(Year))"}, Week = {">=$(=Max(Week)-8)<$(=Max(Week))"}>}EstimatedTaskTime*Tasks)

sum({<DailyTaskType = {'Counts'}, Week = {">=$(=Max({<Year={"$(=Max(Year))"}>} Week)-8)<$(=Max({<Year={"$(=Max(Year))"}>} Week))"}>}EstimatedTaskTime*Tasks)

Re: I want to Add Max Year to My set Analysis

sunny_talwar — Thu, 19 Dec 2019 12:57:39 GMT

Does your week field contain information for the year? for example 201953, 201952 or it is just 53, 52, 51 etc?

Re: I want to Add Max Year to My set Analysis

H_Julian — Fri, 20 Dec 2019 11:46:34 GMT

You can not use Script Functions within the Set Analysis.

To be able to use the Maxfunction you will need to put it in a Variable:

e.g. vMaxYear=Max(Year)

then put the Variable in the Set Analysis:

sum({<Date={$(vMaxYear)}>}

Greetings