b list04

SAQL Binding   

Picklist Binding

a = filter a by ‘SF_Acco.ParentId.Name’ in {{coalesce(column(SF_Acco_Name_8.selection, [\”SF_Acco.Name\”]),\”all\”).asString()}};

Static Step Binding String

{{cell(toggle_selector_3.selection, 0,\”return_measure\”).asString()}}

Static Step Binding Date Range

{{cell(toggle_selector_4.selection,0,\”return_filter\”).asDateRange (\”date(‘INVOICEINSTALLMENTDUEDATE_Year’, ‘INVOICEINSTALLMENTDUEDATE_Month’, ‘INVOICEINSTALLMENTDUEDATE_Day’)\”)}}

Date binding from Date picker

{{selection(INVOICEDATE_Year_4)}}

“pigql”: “q = load \”OpportunityWithAccount\”;\nq = filter q by date(‘CloseDate_Year’, ‘CloseDate_Month’, ‘CloseDate_Day’) in {{selection(step_for_datePicker)}};\nq = group q by (‘CloseDate_Year’, ‘CloseDate_Month’);\nq = foreach q generate ‘CloseDate_Year’ + \”~~~\” + ‘CloseDate_Month’ as ‘CloseDate_Year~~~CloseDate_Month’, count() as ‘count’;\nq = limit q 2000;”

{{cell(INVOICEDATE_Year_4.selection,0,\”return_filter\”).asDateRange (\”date(‘INVOICEINSTALLMENTDUEDATE_Year’, ‘INVOICEINSTALLMENTDUEDATE_Month’, ‘INVOICEINSTALLMENTDUEDATE_Day’)\”)}}

Binding from Chart

a = filter a by {{cell(Region_1.selection, 0,\”Region\”).asEquality(\”REGION\”)}};

Share:

Post a Comment

Your email address will not be published. Required fields are marked *