Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Weekly Moving Average appointments count

Hi,

I have been banging my head on this one a while, I need a Graph that displays the weekly moving average (X = Count of meetings / Y = Weeknumber) the last 6 months.

 

As of now i have a dataset imported from Excel with all the appointement data, each participant is a row in the dataset so there can be several rows for each appointment.

 

Anyone got any tip on how to think on this one, i fear i miss some fundamental stuff, i have tried the solutions from serveral "moving average" threads in the community but with no help.