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 🙏

My Looker:

whanwhan_1-1720782923159.png

What I want:

whanwhan_2-1720782973180.png

 

 

 

 

0 1 148
1 REPLY 1

@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