Data Grid Tour

Data Grid Tour
1013442008-04-30811149114.0 
1013442008-05-28794144613.0 
1013442008-06-25653156012.0 
1013442008-07-231176148611.0 
1013442008-08-201292134311.0 
1013442008-09-171210118612.0 
1013442008-10-151158132013.0 
1013442008-11-121059144214.0 
1013442008-12-10772159115.0 
1013442009-01-07990164514.0 
1013442009-02-041374163515.0 
1013442009-03-041570145515.0 
1013442009-04-011236154916.0 
1013442009-04-291567166115.0 
1013442009-05-271442159415.0 
1013442009-06-241105161814.0 
1013442009-07-221437176514.0 
1013442009-08-191417194614.0 
1013442009-09-161546180915.0 
1013442009-10-14864175114.0 
1013442009-12-091251136215.0 
1013442010-01-061281125016.0 
1013442010-02-03804105517.0 
1035052008-06-04645160011.0 
1035052008-07-16234150014.3 
1035052008-07-30344155013.2 
1035052008-09-17342145012.9 
1035052009-01-06223140016.5 
1038662008-04-301224123513.04729
1038662008-05-28772112314.09818
1038662008-06-25390127114.0 
1038662008-07-23317116916.0 
1038662008-08-20271103914.0 
1038662008-09-17327123415.0530556
1038662008-10-15271108013.0 
1038662008-11-12567108115.0 
1038662008-12-10102088215.0 
1038662009-01-07102273614.0 
1038662009-03-041008109515.0 
1038662009-04-011024103914.0200
1038662009-04-29801117313.0 
1038662009-05-271005123613.0 
1038662009-06-241192134113.0 
1038662009-07-22937139615.0 
1038662009-08-191034143115.0 
1038662009-09-161005137215.0 
1038662009-10-14688148113.0 
1038662009-11-11764167212.0 
1038662009-12-09405185110.0 
1038662010-01-0622317229.0 
1038662010-02-03843187910.0 
1072012008-05-28553194413.055719
1072012008-06-25500198814.027869
1072012008-07-23326183615.05752
1072012008-08-20207186517.01322
1072012008-09-17185168816.0359
1072012008-10-15133149517.0135
1072012008-11-1295163216.049
1072012008-12-1059182416.0207
1072012009-01-0731165214.01073
1072012009-02-0496158315.01848
1072012009-03-04148171015.01391
1072012009-04-01436183017.01720
1072012009-04-29438163215.0608
1072012009-05-27660155214.01500
1072012009-06-24764153816.0520
1072012009-07-22821157314.0318
1072012009-08-19525161914.024
1072012009-09-16790175015.0674
1072012009-10-14677180815.0762
1072012009-11-11603189013.0981
1072012009-12-09347170514.0898
1072012010-01-06304166316.0796
1072012010-02-03519165915.0164
1072012010-03-03508161814.042
1103492008-04-29139097816.0 
1103492008-05-27145797417.0 
1103492008-06-24821116016.0 
1103492008-07-22517131017.0 
1103492008-08-19295139217.0 
1103492008-09-161076152317.0 
1103492008-10-141342146418.0 
1103492008-11-11877161519.0 
1103492008-12-09475157919.0 
1103492009-01-06736166018.0 
1103492009-02-03434176818.0 
1103492009-03-03272195417.0 
1103492009-03-31391180318.0 
1103492009-04-28725184818.0 
1103492009-05-26459179817.0 
1103492009-07-211182174319.0 
1103492009-08-181493161520.0 
1103492009-09-15764162621.0 
1103492009-10-13609174720.0 
1103492009-11-10625163519.0 
1103492009-12-08400180618.0 
1103492010-01-05950195219.0 
1103492010-02-02916210520.0 
1191802008-04-20239180217.00
1191802008-05-18266178718.0600883
You can easily join together columns from different tables to form joined, integrated tables. In many contexts, grids are joined 'behind the scenes' using common columns like participant or cohort identifiers.

Integrate Data from Different Tables

  • Click the (Grid Views) icon and select Customize Grid.
  • The left pane shows available columns, including columns from other datasets.
  • Expand the node Participant ID and select Cohort. (This is a column from a different dataset: "Demographics".)
  • Click View Grid.
  • Notice that the columns are added to the Physical Exam table, creating a hybrid dataset.

Exclude and Visualize

  • Click the Cohort column header and select Filter.
  • Exclude one of the cohorts.
  • To visualize, click CD4+ and select Quick Chart.
  • Or choose another option from (Reports and Charts) -- many other visualization options are available.
===============================================================

Previous Step | Next Step