You need to sign in to do that
Don't have an account?
JavanL
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:
Target step:
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": {} } }
JavanL
Oh and here's the warning I get on the widget when I try to select a different date:
Matt Bostrom
did you ever figure this out? i cant seem to get date bindings to work in compact-form