Insight Test tab shows different results from same record in a view

Issue

When testing an on-demand record in Studio, the sample data shows some field values (like dates) adjusted to a different time zone, however, shows the correct value when that record is placed in a view.

 

Cause

As designed behavior of Test tab processing.

 

Solution

There are configurations that will exhibit this behavior. For example, if the data source used in the record has a date field, and that date field is configured with a Time Zone offset (Studio | Data Sources | {dataSource}) when you select the date field, the Test tab will process that internally (as if it were a pre-calculated record). But when that same record is placed into a view, that logic does not run and presents the data as it resides in the data source's database table.

 

Level of Complexity 

Easy.

 

Applies to  

Product	Version	Build	Environment	Hardware
Insight	6.x

 

 

Article # 3038621