Hey all, I wonder could I get some help with calcu...

# questionsg

gifted-optician-55853

03/28/2023, 2:43 PMHey all, I wonder could I get some help with calculating a metric, please?
We have a product that is used by schools, where each school could have any number of teachers. I’m trying to define a metric where the number of weekly active teachers is a ratio of the total teachers in the school. The individual teachers may not have even signed up so their profile might not be created but each profile we do have has a school identifier. We can also use a lookup table to get the total expected teachers for that school.
Is there a way for me to find the ratio of WAU/Total Users per school?
The problem I’m seeing right now is that WAU is calculated with Events and the Total Users per school is accessed through User Profiles and I can’t use formulas on them both at the same time in Insights.
Any guidance would be greatly appreciated.