Forum Discussion

UmaHarithsa's avatar
UmaHarithsa
Qrew Cadet
6 years ago

Sum of Count of value in 5 fields

I have this data in table -> for every PC, there are 5 Peripherals fields. Each of these Peripheral fields have the same set of dropdowns. This is to allow them to collect up to 5 peripherals that are attached to the PC. I would like to generate a count of each type of peripheral. Below is a sample of what the data looks like:


I would like to create a table where the data below can be pulled as needed (grouped by the location). Is it possible to do this?


Thank you.
Relationships
reports and charts
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    6 years ago
    This really requires a table of records to mimic your 2nd screenshot.  Each Peripheral -field should create a single record as a child-record.  This way you would be able to get your Summary Report by Building Name to tell you the count of Peripherals by Peripheral type.

    You could build an automation, webhook or QBAction to create these records when the Peripheral fields are populated.

    Workstations < Peripherals

    Each Peripheral would be connected to the Workstation and have a single-peripheral name.  You can display/embed these if you want to, or not.