Mixpanel Community Icon

Summing User Test Scores by Attempt ID: A Guide to UI Reports

·
·

Hi I'm trying to determine a user's test result (score) by looking up what score the user got on each of the questions submitted The events are as follows:

  • Test Completed event

  • Test ID

  • Test Attempt ID

  • Question Attempt event

  • Test ID

  • Test Attempt ID

  • Question ID

  • Question Score ( 0 - 3)

A Test Attempt defines one user's attempt at a particular test and generally contains their result on that test. The Question Attempts tracks how the user performed on each question of that test attempt Ideally I want to SUM the Question Score, grouped by Test Attempt ID Is this possible through any of the UI reports?

  • Avatar of Andrew S.
    Andrew S.
    ·
    ·

    What do you want the output to be? The average score? The average broken down by person? Something else?

  • Avatar of Saskia M.
    Saskia M.
    ·
    ·

    I need to show the group's average, min and max score

  • Avatar of Andrew S.
    Andrew S.
    ·
    ·

    It looks like you should be able to do it all with your Question Attempt event as the selected metric. You want to do an aggregate of the Question Score property as the calculation for the metric. And then in the Breakdown, select your Test Attempt ID. You could then sort the results by the aggregate score.

  • Avatar of Andrew S.
    Andrew S.
    ·
    ·

    And presumably the user taking the test is a single user. So you could also look at the aggregate by user as an option. But if a user took two tests, that would then average their scores across both tests.

  • Avatar of Andrew S.
    Andrew S.
    ·
    ·

    I don't have the same data set/structure to demonstrate, but faking it with one of my data sets, it would look something like

  • Avatar of Andrew S.
    Andrew S.
    ·
    ·
  • Avatar of Saskia M.
    Saskia M.
    ·
    ·

    Thanks Andrew that's very helpful