Refer to other Summarize columns in a Custom Expression?

Hello there,

I need to create some % calculations (such as % of Active Users).
Mathematically to achieve that it is (# of Active Users / Total # of Users).

I tried creating two custom Expressions first in the Summarize area, and then attempted to use those both in a 3rd summarize but it does not allow me to refer the first two.

I am wondering as an alternative, if our admins create a two metrics that calculates (# of Active Users) and (Total # of Users) would I be able to refer to those metrics in a Summarize custom expression?

Thank you

2 Likes

no solution for this good use case ?

You have to add another layer of Summarize to reference output from a previous Summarize. In your case though I think you want a custom expression to divide the two to create the percentage.

2 Likes

Ho yeah got it ! Thanks

Hello @dwhitemv

Thanks for the suggestion. I think I had figured it out by now, I created this question in March 2024 when I just started using Metabase and was still a newbie. Great tool.

Thanks