Skip to Main Content
Categories Analytics
Created by Chris Burland
Created on Mar 1, 2024

Creating groups to help cleanse data

Is it possible to create groups in the dataset to help cleanse the data and reduce the number of items? Examples

  1. Ethnicity (would be good to have 3 most common + other – for us this is White British, Pakistani, Indian, Other). Having lots of small groups makes for difficult to read visuals

  2. SEN Level – I want it to only use E, K and N (and put other non-standard labels (EHC application for example) into one of those 3 groups)

  3. Staff Role type (Support or Teaching) – this exists as a field in Every (Job Category), but that isn’t one of the additional data fields, so I was thinking I could create groups from the Post Type field, or the Department field. Ideally, adding Job Role as one of the Data fields would be great.

(n.b. This request applies to student data being imported from SIMS and Staff data being imported from Every HR, but I imagine the principle of being able to create groups would be useful to others)

  • Attach files