Calculated metric and breakdown : a story of table filtering

Hi there,

i created a metric that, by design, seems not able to be displayed in line chart (for example) :

The idea is to calculate some pages visits with homepage as previous screen, and divide this by the total visits of the homepage.

The thing is, it works fine when you put it in a table with all the pages as dimension, because the homepage visits are already calculated in this table. BUT, if you create a line chart for one of these pages or try a breakdown by day (for example) it gives "infinity". The explanation is these two options are, in terms of data manipulation, the same : a new filtered table is created on a specific page for the breakdown, and there's not "homepage" in this new table. So homepage total visits is 0 in this table. Divide something by zero doesn't generally work 😄

I wonder if there was some solution for this. Like an "Except" in PowerBI or something in the calculation, to prevent filtering in the second part of the calculation. Or a method to organize my board to obtain the result.

I think it's limited by design, but i don't know Adobe Analytics as much as other solutions.

Thanks for the help 🙂