Forum Discussion

KennethMelvin's avatar
KennethMelvin
Qrew Trainee
9 years ago

Trying to produce a Summary Report of Multiple Multiple Choice fields.

I have a database with quite a few records that I've created to track a process end to end, but they different types of record use different parts of the whole process. The database stores the dates o...
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
It recommend putting all those "parts/stages" into a child table of the parent project.  Then all your dates would be in one field, all your durations would be in one field, and all your yes/no answers would be in one field, just multiple records.  Then creating the summary reports and durations will be a breeze.

This might take some data export and import, but with some plaining it will be much better in the long run.

And will make your app data structure much cleaner.
KennethMelvin's avatar
KennethMelvin
Qrew Trainee
9 years ago
It's not comparing it vs each other, it's comparing the actual figures to the target figures that they should be under, and seeing how many manage to get below the target and how many don't and counting those numbers.

Your point may be valid, but it doesn't help me with the current problem and will be an extended project that simply isn't going to happen any time soon. I'll look into making those changes, but at best they will need a significant amount of time and effort.