I’ve tried lots and lots of permutations around filters, but cannot get a simple index to give me the correct values.
I have a table with actions with an open/closed flag a project field and others. For my test, all I wanted was a simple count of Open actions for a specific project.
No matter what I put in the filters, all I get is the total number of records (unfiltered).
I don’t need a period, but If I add the period I get a random number less than the total records, but never the correct one!
Is this a fault or am I missing something in the setup. Needless to say, the help is worse than useless… it just lists the fields without saying how to use them!
I could write an SQL in seconds to do this…it would simply have a WHERE filter 1 AND filter 2… but there is no place to add user specific SQL (an omission I think!)