I have an app which contains information on which days of the week someone attends a group. I have various filtered views which show "X group on Monday, Y group on Monday, X group on Tuesday" etc - but at best I can only set up one view per day. I would like to be able to filter my view to show "if they attend any group", but can't figure out how to do this.
I can set a filter to show the records where there is no group set, using "not set" for each day - but can't see how to do the reverse and filter where "any group/day" will show. Setting up a filter which shows any group for more than one day only finds records where someone attends more than one day per week, which is not enough as most people only attend one day.
Can anyone help me? I would have set up a calculation to show "@Monday group ? 1 : 0, @Tuesday group ? 1 : 0" etc, and then filter on whether that field is greater than 0, but can't get the relationship field to pick up in the calculation.
Please sign in to leave a comment.