feat: create queries for the 4th and 5th card with more context if data is partial

[OmarIthawi]

Same issue:

• https://github.com/Zeit-Labs/dashboard/issues/150

{ 'total_learners: 10,122, limited_access: true }

[shadinaif]

resolved in #76

[OmarIthawi]

This has been partially resolved by #76, we need the following 5th statistic:

• Total learning hours: Number of passing students * course.effort

We've shared this stat with the data team and it seems to be approved.

[shadinaif]

nice! thank you @OmarIthawi !

[OmarIthawi]

@shadinaif, please let me know when this is implemented in staging so we can add it the frontend.

[OmarIthawi]

@tehreem-sadat Please let me know if you or Shadi can get to this task any time soon.

It's about time that we add this metric to our homepage so it looks complete :)

cc: @shadinaif

[tehreem-sadat]

@OmarIthawi started working on it yesterday, I;ll let you know when it is done.

[shadinaif]

@OmarIthawi as I remember from a previous discussion; the number of passing students is counted according to certificates. Please let us know if that changed for any reason

[OmarIthawi]

@shadinaif I'm unsure what you mean.

All the existing cards are great!!

We need the fifth one as mentioned here #67 (comment)

This has been partially resolved by #76, we need the following 5th statistic:

• Total learning hours: Number of passing students * course.effort

We've shared this stat with the data team and it seems to be approved.

I hope that makes it clearer

[shadinaif]

@OmarIthawi I mean: your proposed equation contains Number of passing students. I remember we agreed that passing is simply having downloadable certificate, and the data team didn't see a problem with this concept. Has that changed since then?

[OmarIthawi]

having downloadable certificate

Yes, it's [having downloadable certificate] * course.effort.

Thanks for the calrification @shadinaif.