The Fields are already part of a common table that covers the entire project and the various details of it (which means it's a very large table with many fields tracking the process from end to end). In each incident some date fields are used, some are not.
[I'm going to look at pulling out each part into their own table in the future as was suggested, because it would make a lot of sense to do so, and I probably should have done so previously, but that doesn't change the current problem.]
The system is already running and has for quite a while now, and provides normal reports without problems but working out how to show the summarised data (for how many meet the Target and how many do not, whilst not including those who do not provide a value) in a report with multiple criteria (some chosen by the user) has proved a significant problem.
-----
I have the durations worked out and the Multiple choice formula fields to pick out whether the durations meet the target or not (or have 'No Value' ie are Null), but it's how to build a report to do what I need to produce for the User because a normal Report doesn't seem to provide enough utility.
In Quickbase, unless I am wrong, you don't seem to be able to pick out criteria in any summary (only the total number), so I can't pick out how many 'Yes' and how many 'No' there are in each column, which is what the report is trying to display.
I am trying to figure out how it is possible to get that information from the table in a format that works and allows the user to specify their different criteria ( A specific period; Region; Type, etc) grouped by Year (field already created to pick that out),
Region etc
I hope this makes a little more sense now.
