Visualization Options for Calculated Values



  • Avatar
    Brian Cortes

    I'm sharing a screenshot of my F&P BAS class roster report:

    I doubt that it will help you. But I really like the way you talked about presenting data and I'm hoping that we could start a conversation that we could both learn from :)

    Comment actions Permalink
  • Avatar
    Franck Reyherme

    Hi Jerome,

    To address the following issue:

    I also don’t want to show the numbers themselves because we don’t want to label success or failure of a class or teacher by what’s essentially an arbitrary score, because teachers of 5th grade will naturally have bigger raw numbers than teachers of 1st grade.

    Have you considered a “Distance from Target” calculation? For each grade level, you have a specific cut point for being “On Grade Level.” If you visualize the students’ distance from this grade level cut point (could be positive or negative), it should mitigate the issue that 5th grade will naturally have bigger raw numbers than 1st grade.

    I can’t build a customary HTML5 chart because I’m not making Jasper do the calculations. I’ve already done that with multiple variables since I can’t unpivot a dataset (I have 2019_1, 2019_2, and 2019_3 as columns, whereas the better way would’ve been to have two columns: TestingPeriod and Score, with 2019_1, _2, and _3 as values in TestingPeriod instead of columns themselves).

    I don’t entirely follow you here. Can you clarify?

    First, there actually is a way to build a longitudinal HTML5 chart, even if your data is in a wide form (with each testing period as a separate column). It’s too in-depth to describe here, but feel free to book an appointment with me, and I can walk you through it (

    Also, I’m sure you’ve already considered this, but can you clarify why you’re not calculating each student’s growth and then visualizing the results? In other words, for each student, you would calculate the difference between the two scores. Then, you could categorize the growth scores into buckets such as “Negative Growth/Decline”, “No Growth”, “0-5 Levels of Growth”, “5-10 Levels of Growth”, “10+ Levels of Growth”, etc. Then you can create a simple stacked bar chart that shows the count and percent of students that fall into these growth categories for each grade level. Does that make any sense?

    Thanks for clarifying! And thanks for starting this conversation!

    Comment actions Permalink

Please sign in to leave a comment.