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
Matt BostromMatt 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:
"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?