Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table of users as:
Login | date_register (mm-dd-yyyy) |
---|---|
user1 | 01-01-2013 |
user2 | 01-02-2013 |
user3 | 01-01-2013 |
user4 | 01-02-2013 |
user5 | 01-03-2013 |
... | ... |
I need to make report as:
date (mm-dd-yyyy) | Count of users |
---|---|
01-01-2013 | 2 |
01-02-2013 | 4 |
01-03-2013 | 5 |
... | ... |
If i select '01-02-2013' and '01-03-2013', i want to see this report as:
date (mm-dd-yyyy) | Count of users |
---|---|
01-02-2013 | 4 |
01-03-2013 | 5 |
How i may make it? (If i check accumulation checkbox in expression i have counts of user for 01-02-2013 = 2 and for 01-03-2013=3 )
You can use rangesum(above(count(FIELD),0,rowno())) to emulate the full aggregation, and then add advanced aggregation to limit the values to your selection (this requires that your date field's load order is sorted chronologically, as in your sample data).
See attached.
You can use rangesum(above(count(FIELD),0,rowno())) to emulate the full aggregation, and then add advanced aggregation to limit the values to your selection (this requires that your date field's load order is sorted chronologically, as in your sample data).
See attached.
Ty for rapid answer