amount of weeks as divider

[One_day_I_will_know]

Hi,

I’m trying to figure out how to show weekly average of this year’s meetings as a KPI. I am using autocalendar. I have the function for the total of this year’s meetings, but how to add the divider?

Count(

{1<[Unit] = {‘Nordic’},

[ce_meetings.date.autoCalendar.YearsAgo] = {[0]}>}

[ce_meetings.])

Now I should divide this year's total by the amount of weeks passed this year (i.e by the number of current week). Should be very easy, but I just can’t figure out. Could somebody advise me?

[JordyWegman]

Hi,

You can use the following:

Count({1<[Unit] = {‘Nordic’},[ce_meetings.date.autoCalendar.YearsAgo] = {[0]}>}[ce_meetings.])
/
Round((Today()-YearStart(Today()))/7)

// Add this if you only want the finished weeks

(Round((Today()-YearStart(Today()))/7)-1)

Jordy

Climber

[Anonymous · Accepted solution]

divide your expression by week(today()) 
current week of today is 21

[One_day_I_will_know]

Thank you, works great. Why did I spend days wondering how it works, I just don't know 🙂

[One_day_I_will_know]

Thank you Jordy, I will remember this too. Now I chose the simpler solution, which works great for my current need.