1 Reply Latest reply on Nov 20, 2018 4:27 AM by Zhouyi Zhang

    How to show both bar and line on the same plot following an LOD calculation

    john.f

      Hi folks,

       

      Thanks in advance for your help.

       

      I've got a LOD calculation resulting in a max date and a filter resulting only in max dates (within individual) in my output. I'm trying to get a within-group average (across all individuals), following the LOD and filter. See below.

       

      GroupGenderIndividualActivityActivity DateVisit DateMax Visit Date
      AM1SwimNov 1, 2018Nov 10, 2018Nov 15, 2018
      M1WalkNov 2, 2018Nov 15, 2018Nov 15, 2018
      F2SwimNov 1, 2018Nov 12, 2018Nov 16, 2018
      F2RunNov 2, 2018Nov 16, 2018Nov 16, 2018
      F2HikeNov 1, 2018Nov 15, 2018Nov 16, 2018
      M3WalkNov 5, 2018Nov 12, 2018Nov 12, 2018
      M3WalkNov 1, 2018Nov 9, 2018Nov 12, 2018

       

      GroupGenderNumber of WorkoutsAvg number of days between Activity Date and Max Visit DateMax Number of Days between Activity Date and Max Visit dateMin Number of Days between Activity Date and Max Visit date
      AM2(14+8 )/2 = 11148
      F1151515

       

      Additionally, I would like to plot the results of the second table on a bar chart, with the bars representing Avg number of days between Activity Date and Max Visit Date and a line going through all of them showing number of workouts.

       

      Thank you!