Forum Discussion

JoeCrozier's avatar
JoeCrozier
Helper II
4 years ago
Solved

Best visual for longitudinal repeating instruments data

Hello, first time asking a question so please be patient with me.

 

I have data like this: 

protocol_titleredcap_event_nameredcap_survey_identifiershort_titleprincipal_investigatorfilepath_for_protocolis_imaging_manual_includedfilepath_for_imaging_manuanumber_of_patients_expecteapproximate_length_of_theapproximate_number_of_partname_of_research_coordinatemail_address_of_researchany_other_special_instructmethod_of_imageis_this_the_most_recent_veprotocol_information_completecollaboration_survey_timestampis_this_study_feasibleplease_advisecollaboration_survey_complete
protocol test 1protocol_informati_arm_1test 1joewww.google.com1www.cnn.com1005 years20Joe Bob[email protected]nothing special212    
protocol test 1survey_1_arm_1              ########1Looks good to me2
protocol test 1survey_2_arm_1               0I personally hate it2
protocol test 1survey_3_arm_1               1What is this? 1998?  Email it to me2
Study2protocol_informati_arm_1Second studyAli Cwww.life.org0 2255 years40Bob Ross[email protected]nope112    
Study2survey_1_arm_1               0I want a disc instead2
Study2survey_2_arm_1               1Love it2

 

Where most of the rows are mostly blank.  What I'd like to do is create a visual somewhat like this:

 

Where the top visual (whether its a table/matrix/etc) has information from the first row for each respective "protocol_title".  The visual on the bottom right would have the information from the 'other' rows for each protocol_title.   I.e. if I clicked on the top visual to select 'study2', all of the other rows for study 2 would show up in the other visual.

 

To be honest the way I have it set up now (top visual is matrix , bottom visual table) is kind of doing that, but I dont understand why its adding the prefix "first" to everything, and its also adding a whole bunch of useless columns:

 

I had though I could filter the top visual to "redcap_event_name"="protocol_information" and that may help?  Any other suggestions are appreciated.

 

 

Need Help

2 Replies

  • JoeCrozier's avatar
    JoeCrozier
    Helper II
    4 years ago

    Update:  I've tried putting a filter on the top visual, to filter specifically to protocol_information, but because the other visual is linked to it, if that top visual is filtered, nothing will show up in the bottom.  I also understand why its saying "First" and can change that, but its still not the best visual for it.

     

    I've thought one way to do it might be to "split" the raw data into two tables (one with basic info from the top visual and another with comments from the bottom visual) and then merge them back together on protocol title.  Any thoughts are appreciated.