Salesforce Tableau CRM - binding filter - min date static and max date based on date selected by user

0
votes

I need to use binding with start date which is the first date from my dataset and end date is selected by user in date filter. Date_1 is date range from which I need only end date selected by user.

I tried the following solution but is not working. Do you know how I can change it?

q = filter q by date('Date_Year', 'Date_Month', 'Date_Day') in dateRange[1614578400000, {{cell(Date_1.result, 0, "max").asObject()}}]

Only the following is working, but I need to add it in query:

"filters": [

        [

            "Date",

            [

                [

                    1614578400000,

                    "{{cell(Date_1.result, 0, \"max\").asObject()}}"

                ]

            ],

            ">=<="

        ]

    ]
salesforcecrm