The different types of Lists

The different types of Lists

Do you want to advance your knowledge about Lists? Go to our BIMcollab Academy and enroll in the BIMcollab ZOOM Model data extraction course.

When creating a list in BIMcollab ZOOM, you are able to choose between three different list types, each with its own usage goals.  Once created, you will recognize them by the icons in front of the list names:   for the property table,   for the pivot grid and   for the dashboard data. 

Property table

The property table is a simple table with rows and columns. Each row represents a component or group of components. Every column indicates one of the selected properties. 
After creation the following features are available for the table:
  • Show corresponding 3D information
    Clicking on one of the cells in the list will show all components of the selected row in the 3D view
  • Column order 
    Edit the order of the columns by dragging and dropping them in the List results panel
  • Sorting the data
    Click on the column headers to change the order of the data according to the values in the clicked column. The arrow symbols       and    indicate if the column is sorted in ascending or descending order.
  • Filter
    Click on the filter icon next to each column to apply a filter on the results. The available options can vary, depending on the selected column
      
  • Merge uniform rows On/Off
    By enabling 'Merge uniform rows', all rows with identical text values in the columns, will be combined into one row. All numerical values in these merged rows will be summed up.

Pivot grid

The Pivot grid is a table which allows users to summarize model data and visualize relations between components.
  1. Click the list in the Lists panel to show the results in the List results panel
  2. To configure the pivot grid, click the Field list button (1) in the Lists results panel
  3. In the Field list panel, all properties which have been added to the list can be selected and rearranged. The panel consists of the following sections:
    1. All Fields
      This section shows all properties which have been added in the settings of the List. Properties which need to be added to the Pivot grid can be selected.
    2. Filters
      By adding a property to this section, you can add an additional filter to include or exclude certain components by clicking the filter icon  (2)



    3. Columns

      Properties added to this section will be shown as columns in the pivot grid. These properties can be sorted in ascending or descending order (3), and can be filtered
      (4)



    4. Rows
      Properties added to this section will be shown as rows in the pivot grid. These properties can be sorted in ascending or descending order (3), and can be filtered (4)
    5. Values
      Properties added to this section will be shown as calculated values in the Pivot grid. The calculation method for these values can be set by clicking the arrow behind the property (5)





  4. Drag and drop the properties from the 'All Fields' section into the other sections to compose the pivot grid. Dragging anything outside the control will deselect it
  5. Click the Field list button again to close the configuration window
After creation the following features are available for the pivot grid lists:
  1. Show corresponding 3D information
    Clicking on one of the cells in the list will show all components corresponding to the clicked value
  2. Expand or collapse nodes
    Click the arrow    next to the row-values to show or hide data

Dashboard data

In contrast to the other two list types, this one is primarily meant to be used in other applications such as PowerBI. This type is created to be synchronized to BIMcollab and is thus only available for Shared nodes.
At first glance this table is identical to Property tables. However, it has restrictions on editability. Properties should not be changed on a frequent basis because it can cause issues with the connected applications template. 
To learn more about how to share results from dashboard data to Power BI, consult te article  How to get Dashboard data list results in Power BI.
Dashboard data are only available for Connected and Enterprise plans

    • Related Articles

    • Setup Lists in BIMcollab ZOOM

      Lists are used to extract information from IFC models and to share these results within a project. BIMcollab ZOOM users with a license and ZOOM editing rights can create and edit lists. Do you prefer more hands-on learning? Go to our BIMcollab ...

    • Edit Lists

      To be able to create and edit lists in BIMcollab ZOOM, two conditions need to be met: ZOOM license Lists are a ZOOM feature, not a ZOOM Free feature. You need to be logged in with a ZOOM license. Read this article how you purchase a ZOOM license and ...

    • View shared results of Lists

      When the results of a list have been shared by one of the team members, they can be viewed by the whole team in BIMcollab ZOOM and BIMcollab Cloud. For more information on how to share the results, consult the article Share results of Lists with my ...

    • Share results of Lists with my team members

      Do you want to advance your knowledge about Lists? Go to our BIMcollab Academy and enroll in the BIMcollab ZOOM Model data extraction course. When a list is created in the shared node, its results can be shared in two ways. They can be either ...

    • Lists - downloads

      On this page you can find example Lists to help you get started in BIMcollab ZOOM. Example Lists  Example Lists for property table and pivot grid types can be downloaded per language: Dutch Lists English Lists German Lists Portuguese Lists Spanish ...