14 🧪New tables

You will find all the tables under the table tab at the top of your screen.

image-20220913102123040

As you can see there are lots of table you can create from a table simply showing the total links to and from each factor to a visual representation of each respondent’s response to a closed question. The possibilities are large - and increase with the amount of additional data your project has.

14.1 Presets

If you want to keep things simple click the presets button which you will find below the table tabs. Any preset ending with(basic)is also the default filter that you will see when you first click onto that tab, making flicking between presets easy.

The preset button opens a list of shortlinks in the dashboard, these links will take you to the most commonly used tables. Once you have clicked on one of these shortlinks you will be taken to this table. There is a description of what table you are viewing displayed in the dashboard.

chrome_b9xDnWzsba


14.2 Features common to all the tables

14.2.1 Main controls

Each table has a set of controls, which are the same across nearly all the tables.

image-20220913134022864

When the table is set to “Filtered”, the tables respond to any filters you have applied in the left-hand panel of the app, just as the interactive maps do. The table shows data corresponding to the map as it is currently displayed.

If you want to see all the data in one table for the unfiltered map, switch this toggle to Unfiltered.

14.2.2 Search

You can search / filter the whole table by clicking on the equals sign at the top of a column. To search numerical volumes you can type in the vaue you are searching for or you can use > and < to search for values less than or greater than a set number.

chrome_tlYyv8TfPp

14.2.3 Sorting

You can sort the whole table by any column by clicking on the appropriate header:

image-20220913152846255

14.3 Creating your table

There are three possibilties:

  1. A normal table. You simply select the first column you want in the “rows” box and then add any others you need in the “columns” box.

  2. Compressed rows. This happens when you select a field for your rows which is “shorter” than the actual number of rows in the table. For example 5043 , in the factors table you can select level_1_label. Because there are fewer of these than there are factors, the table will be “compressed” and we can choose how we want the multiple results for each row to be displayed – here we have chosen to display all the labels, but we could also have displayed just the number of values.

    image-20220830172706445

Here, we compress the sources table just by the answer to their question on purchasing power 5044, and display several other columns.

image-20220830173110732

This is the same thing, but showing just the counts in each cell: 5045.

image-20220830173313874

  1. Pivot tables. It is possible to construct pivot tables by selecting a column to pivot by: 5046. Again, you can fill the cells with all the values of a field you select, like source_id, or all the unique values, or the counts.

image-20220830173540123

Pivot tables give us lots of new possibilities, like this display of closed questions: 5047.

image-20220830174235089

14.4 Print view

Do you want some preformatted quotes for your report?

chrome_lTHlwBtWAR

Each table can also be shown as simple text for copying and pasting.

If you want printable quotes for your report, there is a table preset for that. Or go manually to the links table, click the 🖨️ button to display Print View, and choose the columns you want. They will be shown in the Print View in the same order. Then just copy and paste using the “Copy” button.

14.5 Formatting your table

Below all tables you will see the below buttons which allow you to format the table as you wish. The columns in table with numerical values can be presented as a heatmap. The higher the number, the darker the colour of the cell will be.

Bottom of table screenshot

14.6 Saving your table

image-20220913134300373

You can copy the data from the tables into your clipboard by clicking Copy , and then you can then paste the data in Word or Excel to create your own tables, graphs, or visualisations.

You can save your table as CSV or Excel. These buttons will export all the data in the current table.

Alternately, you can save the table as a picture or png if you prefer!

Or you can save a link to this table and share it with a colleague just as you with other shortlinks.