I am looking to import Date/Time fields from a Salesforce Report into Quicksight but for some reason when it imports the column returns blank data for that field.
I am basically trying to create a Business Hours field on the report to filter out data that is outside of these hours. I can create a row-level formula on the salesforce report and apply the filter to it, However every time I create a row-level formula, even when it is not added as a column to the report, the import does not work and returns 0 lines of data.
I understand there is a function on Salesforce for Business hours, however, this has never been set up and from what I have read you can’t filter out business hours on reporting anyway.
Is there any way to import date/time fields into QuickSight from a salesforce report or to be able to use row-level formulas in a Salesforce report without having any import issues?