HomeVariablesOrganizing variables

Groups

Groups are sets of variables within sections. You can organise variables into groups by multi-selecting and hitting Cmd/Ctrl+G (or right-click -> group variables). You can also create nested groups (simply create a group under an existing group).

Aside from visual organisation in the spreadsheet, groups can also be used for

  • Easily adding totals in the spreadsheet and on tables:
    • These totals will automatically stay up to date as new variables are added, or existing variables are removed, from the group/section.
    • In the spreadsheet: hit the sum icon at the top of the group/section row.
    • On tables: add a group/section as a series to add its variables as well as a total row. (Hit the sum icon once added to see the total only, or variables only).
  • Using Groups in Functions (within formulas): Easily sum (or avg/min/max...) the variables within the group. Just type sum(Group Name) and Causal will sum all the variables within that group. When variables are added to (or removed from) the group, the function (e.g. sum) will auto-update.
  • Keeping variables on tables in sync with the spreadsheet: If you add a Group to a table (as opposed to the individual variables), then the table will automatically stay up to date as variables are added/removed from the group in the spreadsheet.
  • Table headers: Organise variables under Group Name headers on tables (e.g. Users is the group header in the screenshot below, and the variables underneath are contained in the group). You can toggle this setting off under Display (Show Group Headers).