Crossfilter Data Structure

I have created several dashboards for other datasets, but I am a little confused trying to think through how to best organize this dataset to to build several stackedbar charts.

Students have several tests they might perform at certain timepoints. The tests are organized into groups. I am currently being provided the data in the following layout.

studentID   timepoint   TestA   TestB   TestC   TestM   TestN
    1           0         C       N       -       C       C
    1           2         C       C       N       -       N
    1           8         N       N       C       -       -
    2           0         C       C       C       -       -
    2           4         C       -       C       N       C

Test AC are considered Pre-Tests and MN are considered Post-Tests

I would like to show a StackedBar chart for just the Pre-Tests (A, B, C) with each bar counting the number of tests in each category (C, N, -).

I would also have a second StackedBar chart for the Post-Tests (M, N).

I can not figure how to define the dimension and group based on this structure. Based on previous dashboards I think I need to reorganize the way I store the data.

studentID   timepoint   group      test    status
---------   ---------   ---------  -----   ------
    1           0       Pre-Test   TestA      C
    1           0       Pre-Test   TestB      N
    1           0       Pre-Test   TestC      -
    1           0       Post-Test  TestM      C
    1           0       Post-Test  TestN      C
    1           2       Pre-Test   TestA      C
    1           2       Pre-Test   TestB      C
    1           2       Pre-Test   TestC      N
    1           2       Post-Test  TestM      -
    1           2       Post-Test  TestN      N
    ....

Any suggestions?

链接地址: http://www.djcxy.com/p/32824.html

上一篇: 我应该使用哪些锁定提示（T

下一篇: 交叉过滤器数据结构