• In order to filter dates, one has to create a compute expression, date type, with the following SAQL expression assuming 'foo' is a date field.
  toDate(foo_sec_epoch). After that, create a filter transformation, check the use SAQL box and enter this in the SAQL filter. date(foo_Year, foo_Month, foo_Day) in ["current fiscal_year" .. "current fiscal_year] (to filter rows at the beginning thru the end of the current fiscal year).
  
  Another sample involves day filters vs year filters> date(CreatedDtOffset_Year, CreatedDtOffset_Month, CreatedDtOffset_Day) in ["29 days ago" .. "current day" ]
  

Here is one way to filter a date range. There is a more 'proper way' which is using the .asDateRange() serialization but this works too. A awesome explanation of these bindings  is in  www.salesforceblogger.com by Rikke.  :-) 



"query": "q = load \"{{column(DistrictStep_SAFCreated.selection,[\"datasetSAF30d\"]).asObject()}}\";\nq = filter q by date('CreatedDate_Year', 'CreatedDate_Month', 'CreatedDate_Day') in [dateRange({{column(dayFilter.selection,[\"weekRange\"]).asObject()}})];\nq = group q by 'newContact' ;\nq = foreach q generate 'newContact' as 'Specialist', count() as 'SAF Last Wk';q = order q by 'SAF Last Wk' desc;\n",




You would create a static query called dayFilter and have the following in the JSON.


"dayFilter": {
                "broadcastFacet": true,
                "columns": {
                    "weekRange": {
                        "type": "string"
                    },
                    "Display": {
                        "type": "string"
                    }
                },
                "label": "",
                "selectMode": "singlerequired",
                "type": "staticflex",
                "values": [
                    {
                        "Display": "Nov24",
                        "weekRange": "[2019,11,24], [2019,11,30]"
                    },
                    {
                        "Display": "Dec1",
                        "weekRange": "[2019,12,1], [2019,12,7]"
                    },