Skip to main content
Question

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

  • April 9, 2017
  • 0 replies
  • 97 views
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 of different parts of the process being started and completed (it's in Working days currently).

I've set up a field to compare the duration of each process section vs the targets for the duration of that part of the process. However, that means that all of the 11 comparison fields are Multiple Choice fields that indicate when the Duration is on or below the target with a " Yes", over with a "No", or does not have either a start and/or end date (ie Null value) which produces a 'No Value" entry.

It is quite possible for similar records to omit different parts of the process, thus there will be Null values in the durations as well as 'Yes' and 'No'.

What I would like to do is produce a Summary report with 2 rows (first a count of the 'Yes' and the second a Count of the 'No') for each year.

It would be grouped by Year, Record Type and Module.

My problem seems to be understanding how to build this (and/or whether you need to set up another table to lookup those figures to get that detail) or whether a Summary report might be able to do this (currently I don't see that utility).

Any help would be appreciated.
      This topic has been closed for replies.

      A QuickBase report table.

      So somehow you will have to consolidate your information into a single table.You seem to say that different parts of the process have their records in separate tables.

      Is there a common field that these tables all have? For example can they all linked to a single project number record as children of that record?
      • MCFNeil
      • Registered
      • April 11, 2017
      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
      • Author
      • Registered
      • April 16, 2017
      So, the question that actually needs to be answered, is how do you 'count' the number of times
      and display that beside each other in a report

      The Idea of the Report would be a report over a specific time period (and probably type of Incident also a criteria) and you'd have 'Yes' as the first Row (the count of those that made the target) and below it Row 2; a count of the Durations did not meet their target (but did have a duration because they used that part of the process).

      This sort of thing.

      YES     8        9          13    4         12

      NO      16      15         8     23       15 


      Can that be done (as summary just seems to count the number of Incidents as it's default without any utility at all).

      Some help regarding that would be helpful.
      • KennethMelvin
      • Author
      • Registered
      • April 16, 2017
      I already have multiple choice fields to pick out which hit the targets 'YES' and which don't 'NO'.

      It's largely is there any way I can make a report show the count of 'YES' in a particular field in the 1st row, and the 'Count of 'NO' in the 2nd row.

      It shouldn't be that difficult, because it's easy to do in excel, but it seems to be an area that, at best, is just not obvious how it is possible. At worst, it's something that Quickbase does not seem to be able to do due to the lack of flexibility in the reports.
      Is this what you are after?

      https://yqc.quickbase.com/db/bmp4hpum5
      Actually, in recre axing your post,in that example, while I don't have the Yeses and the Nos in separate riws, you can use the Rows for some other grouping. that you also need.
      Terms & ConditionsAccessibility statement