Average of Every Monday

Options
SwathyShankar
SwathyShankar Member, ALL USERS, Partner, Certified Model Builder Posts: 5 New Contributor
in Planning & Modeling

Hi Team,

I have to find Average of particular Column based on the DATE .

 

(i.e.)

  • To find How many Subjects have been Enrolled in a Particular Site?
  • To find Average of subjects enrolled per week, we are calculating Every Monday(We used WEEKDAY function to get a first day of the week.)

Can any one help me with this?

 

Thanks.

Tagged:

Comments

  • SwathyShankar
    SwathyShankar Member, ALL USERS, Partner, Certified Model Builder Posts: 5 New Contributor

    Hi thanks for your response.

    Actually I missed one thing. Using WEEKDAY function I've found Date's of Monday.

    The thing is that I want to find the average of Subject enrolled in the Site in a particular Date.

    FYI (Subject and Site is a Line Item(not a List))

  • SwathyShankar
    SwathyShankar Member, ALL USERS, Partner, Certified Model Builder Posts: 5 New Contributor

    Hi ,

    You can refer the below Screenshot.

     

    Need to SUM the 'COUNT' Column Group by 'Date' and 'Site' Column.

     

Categories