Set Analysis in Charts with Previous Year data

Wed, 22 May 2013 14:11:25 GMT

How do i insert previous years data into a compliance precentage graph?

I am currently using this expression to calculate the percentage;

=(Sum({$<Target={"62 Day Screening"}>}Acountability)

Sum({$<Target={"62 Day Screening"},[Breach Indicator]={Y}>}Accountability})

Sum({$<Target={"62 Day Screening"}>}Accountability)

*100

I have a slider select for the Financial Year and would like to show the previous years info dependant on which financial year is selected.

Can anyone help?

Re: Set Analysis in Charts with Previous Year data

jonathandienst — Wed, 22 May 2013 14:33:06 GMT

Let's say your slider is linked to variable vFinYear, and you have a FinancialYear field, add the fin year to the set expressions like this

(Sum({$<Target={"62 Day Screening"}, FinancialYear = {"$(vFinYear)"}>}Acountability)...

Add the fin year clause to all the set expressions in the same way as above. Modify the expressions as required to match your data model.

Hope that helps

Jonathan