How to find % in row grouping level

Hello,

Would anyone please suggest me on how to calculate the %lead in each status, group by week. I try with the calculation field, it only give me the percent/grand total (every week).

Kindly suggest if there are specific keywords that I can search and learn for. Thank you :folded_hands:

My Looker:

What I want:

@whanwhan
What we usually do in situation like this is a Custom Query based on your bigquery table which will precalculate those % at each row requested. Custom query only if you want data to be dynamically filtered. If it’s static then single view should be sufficent.

Regards
Arkady Zagdan
Bigglo.pl