Converted datetime field is not calculatable
We were initially converting our time using the FROM_UNIXTIME function in our sql view but this was causing the data to come into Yellowfin already as a timestamp. This was causing issues, including not able to add a timezone converter, thus providing erroneous times on user reports. So we are now importing it as a varchar, then applying to the time conversion at the YF view level.
However the converter YF datetime field is not able to perform any calculation (enddate - startdate, startdate - today type of calculation) - is there any solution / tricks on how we can perform calculation in these converted datetime?