Sorting measures or dimensions

Here is a sample of a table widget with totals with bindings used to sort meaures or dimensions (since faceting is needed to facilitate interactivity of dashboards). Projections need their API names vs. string labeling. Snip is pseudocode(almost)



q = load "Activities";
q_A = filter q by 'Type_of_Call__c' == "Proposal Revision" && 'Proposal_Meeting_Result__c' in ["Maybe - Revise Proposal", "No - Create New Activity", "Yes - Deal is Closed Won!"];
q_B = filter q by 'Type_of_Call__c' == "Proposal Revision" && 'Proposal_Meeting_Result__c' == "Yes - Deal is Closed Won!";
q_C = filter q by 'Type_of_Call__c' == "Initial Call" && 'Result_of_Call__c' in ["CFA, Successful", "No, Successful", "No, Unsuccessful", "Yes, Schedule Meeting"];q_A = group q_A by rollup('{{cell(static_3.selection, 0, "Value").asObject()}}');
q_A = order q_A by ('{{cell(static_3.selection, 0, "Value").asObject()}}' asc nulls first);
q_B = group q_B by rollup('{{cell(static_3.selection, 0, "Value").asObject()}}');
q_B = order q_B by ('{{cell(static_3.selection, 0, "Value").asObject()}}' asc nulls first);
q_C = group q_C by rollup('{{cell(static_3.selection, 0, "Value").asObject()}}');
q_C = order q_C by ('{{cell(static_3.selection, 0, "Value").asObject()}}' asc nulls first);
result = group q_A by '{{cell(static_3.selection, 0, "Value").asObject()}}' full, q_B by '{{cell(static_3.selection, 0, "Value").asObject()}}' full, q_C by '{{cell(static_3.selection, 0, "Value").asObject()}}';
result = foreach result generate coalesce(q_A.'{{cell(static_3.selection, 0, "Value").asObject()}}', q_B.'{{cell(static_3.selection, 0, "Value").asObject()}}', q_C.'{{cell(static_3.selection, 0, "Value").asObject()}}', sum(q_A.'ActivityCount') as 'Proposal Revision', sum(q_B.'ActivityCount') as 'Proposal Revision Yes - Deal is Closed Won!', sum(q_C.'ActivityCount') as 'Initial Call', coalesce(grouping(q_A.'{{cell(static_3.selection, 0, "Value").asObject()}}'), grouping(q_B.'{{cell(static_3.selection, 0, "Value").asObject()}}'), grouping(q_C.'{{cell(static_3.selection, 0, "Value").asObject()}}'))) as 'grouping_{{cell(static_3.selection, 0, "Value").asObject()}}';


result = foreach result generate '{{cell(static_3.selection, 0, "Value").asObject()}}', 'Initial Call', 'Initial Call - Yes Schedule Meeting', 'Initial Call - Yes Schedule Meeting' / 'Initial Call' as 'Yes, Schedule Meeting', 'Presentation Meeting', 'Yes, Quote it - Presentation Meeting' , 'Yes, Quote it - Presentation Meeting' / 'Presentation Meeting' as 'Ratio - Yes Quote it','grouping_{{cell(static_3.selection, 0, "Value").asObject()}}';


summary = filter result by 'grouping_{{cell(static_3.selection, 0, "Value").asObject()}}' == 1;


result = filter result by 'grouping_{{cell(static_3.selection, 0, "Value").asObject()}}' == 0;




HERE IS SORTING BINDINGS THRU TOGGLES
First binding'switch'
{{cell(columnList_1.selection, 0, "sortPivots").asObject()}}result = order result by ('{{cell(columnList_1.selection, 0, "valu").asObject()}}' {{cell(sorter_1.selection, 0, "valu").asObject()}} nulls last);


2nd binding 'switch'
{{cell(columnList_1.selection, 0, "sortMeasures").asObject()}}    
result = order result by ('{{cell(static_3.selection, 0, "Value").asObject()}}' {{cell(sorter_1.selection, 0, "valu").asObject()}} nulls last);


result = union result, summary;


SAQL resolves to ….


q = load "0Fb5x000000ToKGCA0/0Fc5x000007ZFMjCAO";
q_A = filter q by 'Type_of_Call__c' == "Proposal Revision" && 'Proposal_Meeting_Result__c' in ["Maybe - Revise Proposal", "No - Create New Activity", "Yes - Deal is Closed Won!"];
q_B = filter q by 'Type_of_Call__c' == "Proposal Revision" && 'Proposal_Meeting_Result__c' == "Yes - Deal is Closed Won!";
q_C = filter q by 'Type_of_Call__c' == "Initial Call" && 'Result_of_Call__c' in ["CFA, Successful", "No, Successful", "No, Unsuccessful", "Yes, Schedule Meeting"];
q_A = group q_A by rollup('User_Division__c');
q_A = order q_A by ('User_Division__c' asc nulls first);
q_B = group q_B by rollup('User_Division__c');
q_B = order q_B by ('User_Division__c' asc nulls first);
q_C = group q_C by rollup('User_Division__c');
q_C = order q_C by ('User_Division__c' asc nulls first);


result = group q_A by 'User_Division__c' full, q_B by 'User_Division__c' full, q_C by 'User_Division__c' ;
result = foreach result generate c
oalesce(q_A.'User_Division__c', q_B.'User_Division__c', q_C.'User_Division__c') as 'User_Division__c', sum(q_A.'ActivityCount') as 'Proposal Revision', sum(q_B.'ActivityCount') as 'Proposal Revision Yes - Deal is Closed Won!', sum(q_C.'ActivityCount') as 'Initial Call', coalesce(grouping(q_A.'User_Division__c'), grouping(q_B.'User_Division__c'), grouping(q_C.'User_Division__c')) as 'grouping_User_Division__c';


result = foreach result generate 'User_Division__c', 'Initial Call', 'Initial Call - Yes Schedule Meeting', 'Initial Call - Yes Schedule Meeting' / 'Initial Call' as 'Yes, Schedule Meeting'…etc   ,'grouping_User_Division__c';


summary = filter result by 'grouping_User_Division__c' == 1;


result = filter result by 'grouping_User_Division__c' == 0;


--result = order result by ('User_Division__x' asc nulls last);
result = order result by ('User_Division__c' asc nulls last);
result = union result, summary;

---