topic Re: Set Analysis Get Field Selection in App Development

Set Analysis Get Field Selection

Anonymous — Thu, 16 Nov 2017 14:58:29 GMT

Is it possible to have a set analysis which uses GetFieldSelections but if nothing is selected it includes all options. Currently have the following which returns the Feedback Volume for month before the one that is filtered. There is also a filter for division. I am wondering if I can have it default to select all because currently its returns '-' when no Division is selected.

=count({1<Feedback_Day_Start = {">=$(=monthstart(addmonths(max(Feedback_Day_Start), -1))<=$(=monthend(addmonths(max(Feedback_Day_Start), -1)))"}, Division={"$(=GetFieldSelections(Division))"}>}FeedbackFlag)

Re: Set Analysis Get Field Selection

Anonymous — Thu, 16 Nov 2017 15:02:49 GMT

Is it possible to have different set modifiers for each part of the set analysis. The required {1} for the date but a {$} for the Division selection

Re: Set Analysis Get Field Selection

sunny_talwar — Thu, 16 Nov 2017 15:03:20 GMT

May be try using p()

=Count({1<Feedback_Day_Start = {">=$(=MonthStart(AddMonths(Max(Feedback_Day_Start), -1))<=$(=MonthEnd(AddMonths(Max(Feedback_Day_Start), -1)))"}, Division = p(Division)>} FeedbackFlag)

Re: Set Analysis Get Field Selection

Anonymous — Thu, 16 Nov 2017 15:06:28 GMT

Thanks for you help Sunny, I have read about p() and think that may solve it. Is the syntax correct in your example because it gives an error when I try it?

Re: Set Analysis Get Field Selection

sunny_talwar — Thu, 16 Nov 2017 15:08:44 GMT

I don't see anything wrong with the syntax... have you tried clicking okay? does it give you the output you needed? If not, can you share an image of this expression in the expression editor?

Re: Set Analysis Get Field Selection

Anonymous — Thu, 16 Nov 2017 15:14:09 GMT

Here is the expression in the editor

Re: Set Analysis Get Field Selection

sunny_talwar — Thu, 16 Nov 2017 15:16:05 GMT

I think the first part of your set modifier might be the issue... try this

=Count({1<Feedback_Day_Start = {">=$(=MonthStart(AddMonths(Max(Feedback_Day_Start), -1)))<=$(=MonthEnd(AddMonths(Max(Feedback_Day_Start), -1)))"}, Division = p(Division)>} FeedbackFlag)

Re: Set Analysis Get Field Selection

Anonymous — Thu, 16 Nov 2017 15:22:03 GMT

Ahh a missing bracket. Thanks Sunny

Re: Set Analysis Get Field Selection

sunny_talwar — Thu, 16 Nov 2017 15:23:08 GMT

Is it working then?

Re: Set Analysis Get Field Selection

Anonymous — Thu, 16 Nov 2017 15:23:50 GMT

Yes it is working as expected