aggregation with set analysis issue

Mon, 28 Nov 2016 15:55:06 GMT

Hi All!

I hope i can get you to understand my issue,

got a table containing the following fields:

ID, StationID ,Date, Box, Active

i need to present a number counting how many StationsIDs are following these rules:

1. Box= Yes

2. Active= Yes

3. Date= (last max value, already got this from a different table, can call id Max_date..)

3. Date= in last year

I am having issues combining all of these together trying to use Aggr and set expressions..

=Aggr(count(DISTINCT

{$<Date = {"Year to Date"}, Active={"Yes"}, Box={"Yes"}}>}

StationID),max_date,StationID)

Will appreciate any help!

Re: aggregation with set analysis issue

MK_QSL — Mon, 28 Nov 2016 15:57:18 GMT

Provide sample app or dummy data.