Keneland LLCSalesforce Consulting
Back to Blog
Salesforce

Einstein Analytics SAQL Part 2

May 20, 2019

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\)}};