Hi,
I have an indicator who's value is controlled by a date selector. This date selector does not change the reference. This allows me to show that X of N records were collected over the past day, or Y of N over the past 5 days - but N always remains the same.
I also have a category selector, which also filters the same indicator. Now I can say that 'Bob' collected Z of N records. However, what I really want to do is:
- when category selector is blank, indicators reference = N
- when category selector is not blank, indicators reference = X or Y
Example:
- 10 records of a total of 25 were collected in the past day by all staff
- 5 records of a total of 10 were collected in the past day by Bob
Derek Law
