In the attached file, I have a field named "Company" and a field named "LoginDate". I want to find the latest date a company logged in, and count all the logins one year (i.e. 365 days) back from that date. E.g. looking at the Table Box, for company "ABC", the last login date is 5/16/2009, and from 5/16/2008 to 5/16/2009 there are four logins.
I have tried so many different forms of Set Analysis, my mind is swimming with brackets and parantheses. No avail.
You are using the total qualifier total<Company> within an aggregation function (max() ) in an advanced aggregation ( (aggr() function) with two dimensions here (LoginDate, Company).
