
1. Re: Need help creating calculated fields...
hannah.johnson Oct 3, 2016 3:41 PM (in response to M Panda)Hi there,
A FIXED level of detail expression will be most helpful to find the values of those three calculations. FIXED level of detail expressions compute a value using the specified dimensions, without reference to the dimensions in the view. In this case, the FIXED level of detail expression will specify which level of detail to compute the values at.
The first measure, Calculation: (dismissed  display_complete), will look like the following:
{ FIXED [Line ID], [Ad Correlation Id] : SUM(IF [Event] = "dismissed" THEN [Elapsed Time] END)} 
{ FIXED [Line ID], [Ad Correlation Id] : SUM(IF [Event] = "display_complete" THEN [Elapsed Time] END)}
So for every Ad Id in every Line Id, find the value of the event "dismissed" and subtract the value of the event "display_complete". The other two measures will fall along the same lines and use FIXED level of detail expressions as well.
Additional information about FIXED level of detail expressions can be found here:
Hope that helps!
Cheers,
Hannah