Bindings in SAQL Queries-compact vs. non-compact

3/3/2021

0 Comments

Bindings enable the user to interact with the dashboard for flexibility in data visualization. Example below compares using bindings for non-compact and compact SAQL. The 1st is a SAQL in noncompact form which compares a text date (ie cTimeStamp=cTimeStampText) using .AsEquality. The 2nd is an aggregate Flex compact form in the "filters" statement.

"query": "q = load \"zDSForecastXProductLineItem\";\nq = filter q by {{column(qDateTest_1.selection,[\"cTimeStampText\"]).asEquality('cTimeStampText')}};\nq = group q by 'cBUBilling';\nq = foreach q generate 'cBUBilling' as 'cBUBilling', sum('Total_Value__c') as 'sum_Total_Value__c';\nq = order q by 'cBUBilling' asc;\nq = limit q 2000;",

"query": {
                    "measures": [
                        [
                            "count",
                            "*"
                        ]
                    ],
                    "groups": [
                        "cBUBilling"
                    ],
                    "filters": [
                        [
                            "cTimeStampText",
                            [
                                "{{column(qDateTest_1.selection, [\"cTimeStampText\"]).asObject()}}"
                            ],
                            "=="
                        ]
                    ]
                }

"qDateTest_1": {
                "broadcastFacet": false,
                "datasets": [
                    {
                        "id": "0Fb3u000000c7u7CAA",
                        "label": "zDSForecastXProductLineItem",
                        "name": "zDSForecastXProductLineItem",
                        "url": "/services/data/v48.0/wave/datasets/0Fb3u000000c7u7CAA"
                    }
                ],
                "isGlobal": false,
                "label": "qDateTest",
                "query": {
                    "measures": [
                        [
                            "count",
                            "*"
                        ]
                    ],
                    "groups": [
                        "cTimeStampText"
                    ]

0 Comments

Meliora Insights, LLC

Data Cloud | CRM Analytics (TCRM / Einstein Analytics) Consulting
meliora - 'for the pursuit of the better'

A blog series distilling quantitative concepts /use-cases in CRM Analytics (Einstein Analytics).

Bindings in SAQL Queries-compact vs. non-compact