You need to sign in to do that
Don't have an account?
Matt Bostrom
Wave Analytics - Binding Dates
Hello I have some filters (not global filters just selections) on my Wave Dashboard. I can bind these values across different data sets no problem but only if the values are not dates. Once they are Dates I am not able to find a way to bind them successfully.
my filter step looks like this:
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_bindings.meta/bi_dev_guide_bindings/bi_dashboard_bindings_functions_wave_designer_asDateRange.htm
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_bindings.meta/bi_dev_guide_bindings/bi_dbjson_relative_dates.htm
Does anyone have any ideas?
my filter step looks like this:
"opty_close_date_filter_step": { "broadcastFacet": true, "datasets": [ { "id": "0Fb1a000000IIfwCAG", "label": "Company Opportunities", "name": "Company_Opportunities", "url": "/services/data/v43.0/wave/datasets/xxxxxxx" } ], "isGlobal": false, "query": { "measures": [ [ "count", "*" ] ], "groups": [ "CloseDate_Year", "CloseDate_Month" ] }, "receiveFacet": true, "selectMode": "single", "type": "aggregateflex", "useGlobal": true, "visualizationParameters": { "options": {} }then the step that refers to the lead dataset with the ConvertedOpportunityId.CloseDate looks like this:
"converted_leads_step": { "broadcastFacet": true, "datasets": [ { "id": "xxxxxx", "label": "Company Leads", "name": "Company_Leads1", "url": "/services/data/v43.0/wave/datasets/xxxxxx" } ], "isGlobal": false, "label": "Converted Leads", "query": { "measures": [ [ "count", "*" ] ], "filters": [ [ "IsConverted", [ "true" ], "in" ], [ "Owner_Zone__c", "{{column(region_filter_step.selection,[\"Opportunity_Owner_Zone__c\"]).asObject()}}" ], [ "ConvertedOpportunityId.StageName", "{{column(stage_filter_step.selection,[\"StageName\"]).asObject()}}" ], [ "ConvertedOpportunityId.CloseDate", "{{column(opty_close_date_filter_step,[\"CloseDate\"])).asDateRange()}}" ] ] },But once I add that last part about the CloseDate its not working. I have read through these articles and tried many different things with no luck yet:
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_bindings.meta/bi_dev_guide_bindings/bi_dashboard_bindings_functions_wave_designer_asDateRange.htm
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_bindings.meta/bi_dev_guide_bindings/bi_dbjson_relative_dates.htm
Does anyone have any ideas?