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.
|Group||Gender||Individual||Activity||Activity Date||Visit Date||Max Visit Date|
|A||M||1||Swim||Nov 1, 2018||Nov 10, 2018||Nov 15, 2018|
|M||1||Walk||Nov 2, 2018||Nov 15, 2018||Nov 15, 2018|
|F||2||Swim||Nov 1, 2018||Nov 12, 2018||Nov 16, 2018|
|F||2||Run||Nov 2, 2018||Nov 16, 2018||Nov 16, 2018|
|F||2||Hike||Nov 1, 2018||Nov 15, 2018||Nov 16, 2018|
|M||3||Walk||Nov 5, 2018||Nov 12, 2018||Nov 12, 2018|
|M||3||Walk||Nov 1, 2018||Nov 9, 2018||Nov 12, 2018|
|Group||Gender||Number of Workouts||Avg number of days between Activity Date and Max Visit Date||Max Number of Days between Activity Date and Max Visit date||Min Number of Days between Activity Date and Max Visit date|
|A||M||2||(14+8 )/2 = 11||14||8|
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.
Can you provide a sample workbook?