I have a large dataset with multiple columns but the ones that matter are ID, date of session and weeks since registration (like the image - fake data). Essentially, I would like to plot a line graph with the week_since_registration on the x axis and the value of the line being the average number of sessions per week_since_registration. For example, in the first week from registration, an average of XX sessions across all ID’s (each row is a session). I have tried to do distintCount(date_of_session, [ID, Week_from_registration]) but that does not work - anyone have any ideas?
@Joe1 can share an example
Do you expect column “weeks_since registration” to be shown on x axis?
Who you say "average number of sessions per week since registration, if I take the 1st as an example, what is the number you expect?
If I count the number of ID, it should be 5. or you expect it to be 4(1, 5,2,7) and divided by 6(1,2,3,5,6,7)?
You may create a calculated field like below to count the number of ID divided by distinct ID. However, ID 4 is not available in the example. I have manually added a row and assume it will be available in your dataset