Formula Columns

Scorecard formula columns allows you to create a column that is derived from values in other columns. Here are some use cases for formula columns:

  • Show temporal fluctuations. For instance, you could add a column filtered by last month and another column filtered by this month. And then add a third column, a formula column, defined to show the percent increase/decrease between both months.
  • Show spread between segments. For instance, you could add a column filtered by Gender – Men and another filtered by Gender – Women. And then add a third column, a formula column, defined to show the difference between the segments.
  • Show favorability gap. For instance, you could add a column filtered by respondents that are favorable to a brand and another filtered by respondents that are not favorable to that brand (you would have to create those segments). And then add a third column, a formula column, defined to show the difference between the segments.
  • Once you click on Add a Formula Column, or edit an existing one, the system presents the column formula editor:

    If the column formula editor looks familiar, it is because it is. It is the same editor used to defined scores. The only difference is that the variables available are columns that you have already added to the table, instead of response counts for question options. The columns are represented by labels of the format {c1} (for the first column), {c2} (for the second column), etc.

    In the example above, the formula presents the spread between column 3 and column 2. If columns are reordered, the formula automatically update. Please see Advanced Formulas for more on Formulas.

    Do you still need help?

    We are always available to answer your questions. For the speediest service, please email support@civicscience.com.