Insight (OBIEE) Tips | Removing the timestamp from a date
Have you wondered how to get rid of a timestamp in a date column? Here’s a method..
Here is a simple email report that shows the total sends on a given date.
Subject area: Email Analysis by Send Date
The problem is that i don’t want to see the total sends by day and time… I want to a total by day.
Let’s fix it!
Email Send Date vs Calendar Day attributes
First off, instead of Email Send Date, use the Email Send Calendar attribute called Day. Why? This attribute rolls up all emails sends by day. Whereas the Email Send Date is the date and time of the email send.