'Combine Parameters in Google Data Studio

I have 3 different parameter sets for calculating Goals in percentage but all 3 have common labels. I basically want to combine these 3 parameter sets into one set so it will be easy for me to filter while using Dashboard.

Here is the dashboard: https://datastudio.google.com/u/0/reporting/eec5311e-5edf-4c82-8d5b-0c3d387e7b56/page/QHznC/edit

Region Leads, Region MQLs and Region SQLs are parameters which I have created and they help me in calculating goals. The labels for them are same but they contain different numerical values based on goals to attain.

Here is the spreadsheet: https://docs.google.com/spreadsheets/d/1Jc3T5S0EqblsEb61-z_7XQuwH0qq2Ccrm0FFv66KqGY/edit#gid=0 I tried using CASE WHEN query but it did not work from my side. Please help! Thanks in advance!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source