Filter data based on startdate

I am fetching date from portal report to SAIL report, but filters are not working in SAIL.
Following code I have used.
local!transactionSummaryData:getportalreportdatasubset(
reportid:cons!IQ_TRANSACTION_SUMMARY_REPORT_ID,
paginginfo: topaginginfo(1,-1),
contexids: {},
filters: if(ri!starttime = "Last 1 Day",{field: 10 , operator: "LESS_THAN", value: 2},{field: 10 , operator: "LESS_THAN", value:5000}),
if(ri!starttime = "Last 7 days",{field: 10 , operator: "LESS_THAN", value: 8},{field: 10 , operator: "LESS_THAN", value:5000}),
if(ri!starttime = "Last 1 Month",{field: 10 , operator: "LESS_THAN", value: 31},{field: 10 , operator: "LESS_THAN", value:5000}),
if(ri!starttime = "Last 2 Months",{field: 10 , operator: "LESS_THAN", value: 61},{field: 10 , operator: "LESS_THAN", value:5000}),
if(ri!starttime = "Last 3 Months",{field: 10 , operator: "LESS_THAN", value: 92},{field: 10 , operator: "LESS_THAN", value:5000})
...

OriginalPostID-150592

OriginalPostID-150592

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data