Highlighted

Total Seconds spent metric gives different numbers when pulled from data warehouse

A9D5RZZ

02-07-2020

Hi Champions,

I have facing bit weird issue in one of my report, I am extracting a Data Warehouse report from Adobe Analytics using following dimensions Country(prop12) > Division Description > Product and using Total Seconds Spent as metric however i see huge difference when pull same metrics from data warehouse against when I run same report in workspace. For example I see 1174 seconds in workspace and for same line item i see 11000 seconds in data warehouse.

 

What could be the reason behind this discrepancy? Am i using wrong metric against set of dimensions?

 

 

data warehouse total seconds spent