Hey, anyone knows how to calculate page level metrics (keeping constant Page URL dimension).

What I need to to build a table with:

Page URL > Page viewed event > Engaged event > Page engagement rate

The page engagement rate is calculated as follows: (number of engaged events / number of page viewed events) * 100. However, I'm unsure how to calculate this in Amplitude. I’ve attempted various methods to implement this formula, but for some reason, the results don't align with the engaged/page viewed values when I use the calculator.

Again the metric must be page level, not session or user level.

Many thanks to anyone that can help