×
Menu
Index

Data Filtering

 
One of the more powerful features of Tabular Space Data is that it allows you to apply data filtering to control which rooms are actually displayed in a tab. By default, all selected rooms will be displayed, but by filtering the data you can limit the grid to display to only those rooms that meet a set of criteria that you choose.
You can apply a filter on any available column (including columns not currently in the tab) and each filter can contain up to ten conditions – you have control over how the filter treats each of these conditions. In addition, you can define the way an individual filter applies its conditions – by default, the filter will be set so that data is only displayed if all conditions are met, but you can also set it to pass if any of the conditions are met or if none of the conditions are met.
 
This section explores how to create, edit and manage filters on your tabs.
 

Filtering Basics

 
Adding a Filter to an Existing Column
The quickest way of filtering is to simply define data filters on one or more of the columns currently visible in the tab. To do this, right-click on the column you wish to filter on and select Add Filter on <column name> from the context menu. This will display the Custom Filter window in its default state, as shown in the following example for Room Name:
By default, the window allows you to enter a single condition – the condition type can be chosen from the dropdown list, while you then type the condition value into the text box. The available condition types depend on whether the cell is textual or numeric. Textual data (such as Room ID, Room Name, Variation Profile and so on) offers the following condition types:
-          Value is “<your condition>”
-          Value is not “<your condition>”
-          Value contains “<your condition>”
-          Value does not contain “<your condition>”
-          Value begins with “<your condition>”
-          Value ends with “<your condition>”
In comparison, numeric data (such as Volume, Floor Area, Solar Reflected Fraction and so on) offers the following condition types:
-          Value equals <your condition>
-          Value does not equal <your condition>
-          Value is less than <your condition>
-          Value is less than or equal to <your condition>
-          Value is greater than <your condition>
-          Value is greater than or equal to <your condition>
 
If you require more than one condition on a single column, you can add another condition row by clicking the + button:
 
 
If you have more than one condition defined, you can remove an individual condition by clicking on the button next to it. Note that the order in which the conditions are defined is not important, and text values are not case-sensitive.
 
Consider the following rooms selected in a model:
If a Room Name filter was defined as in the previous example (begins with “L00” and does not contain “void”), the results of the filtering would be as follows:
Only four of the rooms can pass both conditions defined in the Room Name filter, so those are the only rooms displayed in the tab. Note that the other rooms are still selected – they are just being hidden from the grid by data filtering.
 
 
Identifying Filtered Columns
When a filter has been defined on a particular column, a blue identifier bar is shown at the bottom of the column header. This allows you to quickly identify which of the current columns have filters applied. In addition, you can get a summary of the filter if you move the mouse pointer over this blue bar:
Clicking the Edit the filter… link in the balloon will also allow you to make changes to the filter conditions.
 
Editing a Filter on an Existing Column
The process for editing a defined filter on a column in the grid is very similar to that for adding a filter. To do this, you can right-click on the column you wish to filter on and select Add Filter on <column name> from the context menu, or click on the link in the summary balloon (see previous section). This will display the Custom Filter window, pre-populated with the conditions defined in the filter:
The Custom Filter window functions in exactly the same way as it does when you are adding a new filter – you can use the + and buttons to add and remove conditions on the filter and can configure the application of the conditions using the Show data when… dropdown.
 
Removing a Filter on an Existing Column
When a filter is defined on one of the columns in the active tab, it is trivial to remove the filter if you no longer require it. Simply right-click on the column you wish to remove the filter from and select Clear Filter from <column name> - the filter will be removed and the data grid will be refreshed accordingly.
Once the filter is removed, the blue indicator band will be removed from the column header.
Disabling Filtering on a Tab
You can temporarily disable the effects of data filtering on a tab to show all selected rooms in your model without actually having to delete the defined filters. This enables you to quickly compare the results of the filtered and unfiltered room attributes. Filtering is enabled on a tab by default, but you can disable it by turning off the Filtering Enabled item in the Tabular Edit Tab menu, or by right-clicking on the tab itself selecting the equivalent item from the pop-up menu:
When filtering is disabled, any columns with data filters applied will change their indicator bar from blue to dark grey – the grid will then refresh to display the room attributes for all selected rooms.
To re-enable the defined filters, simply re-select the Filtering Enabled menu-item.