Tinderbox 8 Icon

Crosstabs controls

Crosstabs controls

The attributes to be viewed are displayed in the two buttons at the top of the view. Pressing the Rows or Columns button to change the target attributes. The resulting popover window also lets you set the maximum number of rows or columns to use; setting the limit to the upper bound (25 rows or columns) asks Tinderbox to display a separate row or column for each unique value. For Boolean attributes, there are only ever two bins. Set and List attributes always have unlimited bins, allowing each tag or element its own bin. For Date attributes, the date "never", if present, is always placed in its own bin.

At the bottom of each cell that is not empty, Tinderbox shows the display attribute of one note in the cell. The Display attribute is typically $DisplayName, but may be any attribute, use the button to set the desired attribute.

The gear-wheel icon opens a pop-up menu offering a number of ways to export data from the view:

  • Export As CSV. This exports the table including column/row labels and totals to a comma-separated variable (CSV) file; an OS file same dialog is shown for saving the file.
  • Export As TSV. As above but in Tab-delimited text (TSV) format.
  • Copy TSV To Clipboard. The table in TSV format (see above) is copied to the clipboard.

In the second row of controls, the Container pop-up control allows the view's default scope of 'entire document' to be changed to any container in the current document.

The Style popup lets you choose, using a pop-up menu, to display either:

  • the count of notes in each cell
  • the percentage of in-scope notes in the cell.

The Bar shows, by default the relative location of each note in the cell in the document’s outline (using $OutlineOrder). The left edge of the bar corresponds to the first descendant of the chosen container, and the right edge corresponds to the last descendant of the chosen container. A vertical line representing each note appears in the note's outline colour.

Query allows the container choice to be (further) constrain using a query added in the box. As the query is applied to the container

A tick-box offers the optional of a Heatmap that will colour cells in proportion to the number of notes they contain, using the system accent colour ($AccentColor) for sparsely-populated cells and the complement of that colour for heavily-populated cells.

The notes viewed in the crosstabs view may be all the notes in the document, or may be restricted to those inside a specific container. Select the desired container from the Container popup menu.