Insights - count for each date
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