Filter element to restrict recent days data in Information Link - Using a date column in Sting type
I wanted to create an information link using Athena JDBC drive from the Athena source table.
I have a "date" field which is of type "String" in the table. I am able to cast the type as Date in the Spotfire while building the dashboard.
But when I try to get in only the recent few days data(say 10 days) into the information link using the Filter element, I face an issue. Filter element provides an option to include only the data source fields and not any other elements already created. As the date field in the table is of type string, I am unable to use that effectively in the filter element. Even when I try cast method or as DATE stuff in the expression it does not help me in this case.