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

Avatar

Avatar
Ignite 1
Level 1
A9D5RZZ
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Ignite 1
View profile

Avatar
Ignite 1
Level 1
A9D5RZZ
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Ignite 1
View profile
A9D5RZZ
Level 1

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?