You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Insight (OBIEE) Tips: How to force blank values to display as 0

Received Response
in Eloqua 2 comments

You may have noticed metrics in your Eloqua Insight reports showing blanks as well as 0s.

Here is an example email analysis:

The blanks actually represent a NULL - meaning there is no value for that metric. In the case of bouncebacks you will only see values for hard and soft bouncebacks if there was a bounceback (i.e email delivery is less than 100%). On the other hand, Total Bouncebacks does show 0s. This is because the metric is using an aggregated table. An aggregated table stores the pre-coumuted results of Total Hard and Total Soft bouncebacks. So in the case of an aggregated table, you will see 0 instead of a NULL value.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!