topic Set Analysis Restriction in App Development

Set Analysis Restriction

deerhunter — Tue, 09 Aug 2016 17:24:25 GMT

How can i limit a sum in set analysis for totaling quarter end monthly counts even if the user

picks multiple months from a filter box.

example: User picks (Jan, Fed, Mar) and only march counts get summed.

swuehl — Tue, 09 Aug 2016 17:53:07 GMT

Maybe like

Count({<MonthField *= {'Mar','Jun','Sep','Dec'}>} FieldToCount)

Wed, 10 Aug 2016 11:57:20 GMT

Data:

Load * Inline

[

Date, Value

01-01-2016,100

15-01-2016,10

31-01-2016,10

01-02-2016,20

15-02-2016,34

28-02-2016,45

01-03-2016,78

15-03-2016,90

31-03-2016,200

];

//Make a variable for maximum date in variable overview

Let vMaxDate= Max(Date);

Expression would be :

IF(Num(Month(vMaxDate))%4=0,

Sum({<Date={">=MonthStart($(vMaxDate))<=MonthEnd($(vMaxDate))"}>} Value)

)