I have a query that is returning data for two dates, a send date and a reward date. The way the process works is that we send out emails to customers about promotions and then as they are used each subsequent day the rewards are added to the customer records and then used.
So, we might send 1000 emails and then for the next 10 days 10 are used each day.
The question I have is how to get the emails sent (deployments) to total and only show on the day they were sent, which is always the first day (MIN date). Right now, the data being returned is breaking down the emails sent by days (which aligns with the loaded numbers incorrectly) that match +/- 1 the loaded count.
What I would like to have the report do is have the total deployed show on 8/31/2018, all the other days would then be blank, for deployed count, while the Rewards Loaded and Rewards Redeemed would still show the daily records.
It would look like this:
Is there a way to SUM the Deployment Count at the Minimum date and only have it show once. I can get the SUM to show up with a FIXED calculation but it looks like this in the report:
Would you be able to provide a sample packaged workbook so we can take a closer look? This will help us to better understand the structure of your data, the charts you’re trying to create, etc.
