function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
JavanLJavanL 

Wave - Unable to bind date filter to a step using different dataset

Hi,
In Wave, I been unsuccessful filtering a step (chart widget) from one dataset with date information from a step in another dataset.
I'm using a selection binding and attempting to bind using the compact format and not the SAQL(pigql) format.
Does anyone have an idea of what I might be missing?
Thanks.

Below is a snippet of the JSON that I have:
Source (date) step:
"TradeCreateDate__c_Y_1": {
                "datasets": [
                    {
                       ...snip...
                    }
                ],
                "isFacet": true,
                "isGlobal": false,
                "label": "",
                "query": {
                    "measures": [
                        [
                            "count",
                            "*"
                        ]
                    ],
                    "groups": [
                        "TradeCreateDate__c_Year"
                    ]
                },
                "selectMode": "single",
                "type": "aggregateflex",
                "useGlobal": false,
                "visualizationParameters": {
                    "options": {}
                }
            },


Target step:
"prod_by_strat_1": {
                "datasets": [
                    {
                        ...snip...
                    }
                ],
                "isFacet": true,
                "isGlobal": false,
                "label": "prod by strat",
                "query": {
                    "measures": [
                        [
                            "sum",
                            "TradeAmount__c"
                        ]
                    ],
                    "groups": [
                        "Test_Mo.StrategistName"
                    ],
                    "filters": [
                       ...snip...
                        [
                            "TradeCreateDate__c",
                            "{{row(TradeCreateDate__c_Y_1.selection, [0], [\"min\",\"max\"]).asObject()}}"
                        ]
                    ],
                    "order": [
                        [
                            -1,
                            {
                                "ascending": false
                            }
                        ]
                    ]
                },
                "selectMode": "single",
                "type": "aggregateflex",
                "useGlobal": true,
                "visualizationParameters": {
                    "visualizationType": "hbar",
                    "options": {}
                }
            }

 
JavanLJavanL
Oh and here's the warning I get on the widget when I try to select a different date:
This widget can't be displayed because there is a problem with its source step:
Cannot read property '0' of null

 
Matt BostromMatt Bostrom
did you ever figure this out? i cant seem to get date bindings to work in compact-form