Forum Discussion

HiltonS's avatar
HiltonS
Frequent Visitor
9 years ago

More than once a week

Hi Guys   I am currently working with attendance data of school learners. I would like to use a measure to calculate how many learners have attended more than once in a week across all weeks to dat...
HiltonS's avatar
HiltonS
Frequent Visitor
9 years ago

See below my direct adaption to what you sent me.

My version

 

It doesnt seem to give any values.  What have I done wrong?

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
9 years ago

HiltonS

 

Thanks for posting your file - useful to have a look at your actual data.

 

Haven't had a chance to work out the solution, but there are two issues I can see:

  1. My measure looks back at the entire Date table. In your case, you have weeks in the Date table before the first Attendance record, so all the Learners are deemed to have zero attendance in those weeks, meaning the measure returns (blank). I think we should adjust the measure to only look back as far as the earliest date in the Attendance table.
  2. My measure as it stands performs quite poorly using your dataset (which is <400,000 rows), so will have to find a more efficient way of applying the same logic.

I will have a look into these points and get back to you. Let me know if you make any progress yourself.

 

Regards,

Owen :)