TIP: While colours and shapes can be defined in the imported metadata table file, the
__shapecolumns are not displayed in the metadata table panel, since they are configuration columns and not metadata columns. To view the information in those columns, you can download the CSV file from the project.
<FIELD NAME>_colourcorresponding to the colour column, these will be used as categorical values. (e.g. if you want to define the colours for the '
country' column, add a column to your data called '
country__colour' (or '
country__color') before importing to Microreact)
__colourcolumn is defined
__colourfield has not been specified for a column in the metadata sheet, a categorical colour palette with 24 qualitative colours will be used.
__colourcolumn, you can override those colours by manually setting them in the colour palette box.
TIP:When a column is used in many of your team's Microreact projects, you can define the colours in a reference spreadsheet . The image below shows and It's possible to standardise colours for a frequently-used column across all your team's Microreact projects, create a spreadsheet containing the colour codes. One column should contain the data values to colour, with another column (named with __colour) containing the hex codes for the colour values (or colour names). Pull those values into your metadata table using Data-flo using the extend-datatable adaptor.
__shapecolumn. If there is no "Shape Column" shown in the Labels, Colours, and Shapes menu, then no columns have a corresponding
__shapecolumn. All columns with a corresponding
__shapecolumn will be available for selection in the Shape Column dropdown.