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

Insights - count for each date

in Eloqua 2 comments

Hi!

Got a question in regards to Eloqua Insights and one of the reports i'am working on right now. As you can see below I am trying to show number of subscriptions per day in X period of time + running sum ( so i can present trend cumulative chart). Running sum works fine; what I struggle with is Total subscribed contacts per day. I would like to show is a TOTAL of contacts subscribed per day:

so 1/19/2019 | 482 | 482

     1/21/2019 | 4 | 486

     1/22/2019 | 6 | 492

etc

I'am pretty sure there is something wrong with date column and the way I have used CAST function

Where i have used extract day of the year - it works fine. However i would like to present findings as calendar dates and not #of day

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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