# Email report by individual email send date without empty dates or aggregation **URL:** \ **Category:** Dashboards & Reporting\ **Tags:** enterprise\ **Created:** [November 13, 2023, 3:52pm UTC](https://community.hubspot.com/t/email-report-by-individual-email-send-date-without-empty-dates-or-aggregation/93889 "2023-11-13T15:52:21Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![karenkaz](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karenkaz/32/67592_2.png) [@karenkaz](https://community.hubspot.com/u/karenkaz)\ **Post date:** [November 13, 2023, 3:52pm UTC](https://community.hubspot.com/t/email-report-by-individual-email-send-date-without-empty-dates-or-aggregation/93889/1 "2023-11-13T15:52:21Z")
I’m trying to create a basic open rate, click rate, clickthrough rate report for emails in a particular campaign with the sent date on the x axis. I can easily build this report but I can’t figure out how to configure it to display the way I need it. I don’t want the sent date frequency set as daily because then it shows a bunch of dates with 0 because no email was sent on that date. Similarly, weekly/monthly/etc frequencies don’t work either because although this email is sent once a month, there are rare occasions when the send date gets shifted (so we’ll have one month with 2 sends and the following month with 0 ). I want each email send to be its own point on the x axis without aggregation, but also not displaying a bunch of dates with no data. Here’s what it looks like if I set up up with send date - daily: ![daily.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/3/c3ddf1c7b4c43ef5f9ae68d534dee1d91c611532.png) And here it is with Send date - Monthly (You can see what happens when two emails are sent in a month and 0 in another month. Not helpful from a visualization perspective.) ![monthly.png](https://d2qpr2jzcazej7.cloudfront.net/original/1X/bc8b8f6a943fe14b6fdc88d313584e4621f5fe48.png) If I set it to daily and use the Min/Max chart settings to set the minimum to 1%, it does filter the empty dates out, but it keeps the bars/lines super skinny and hard to read. ![min skinny bars.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/b/b838760b43c8368670db704a7da0bc13cef764fb.png) My stakeholders are asking for what I think is a pretty simple report: to display a full year of open, click, and clickthrough rates by individual email issue/email send. What am I missing? How would you set up this report? They already have a dashboard I’ve created for them, so I’m looking for a report that can be added to a dashboard, not asking them to look at each email individually. ---
**Author:** ![PamCotton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pamcotton/32/47916_2.png) [@PamCotton](https://community.hubspot.com/u/PamCotton)\ **Post date:** [November 13, 2023, 11:31pm UTC](https://community.hubspot.com/t/email-report-by-individual-email-send-date-without-empty-dates-or-aggregation/93889/2 "2023-11-13T23:31:32Z")
Hello @karenkaz, thank you for posting in our Community! Amazing way to start a conversation, thank you for providing all these helpful details. Could you let me know if the report you’d like to create seems more like an[attribution report](https://knowledge.hubspot.com/reports/understand-attribution-reporting)or a[customer journey report?](https://knowledge.hubspot.com/reports/create-a-journey-report) I want to invite some of our top experts to share their thoughts @jolle @crispyGTM @HFisher7 any recommendations for @karenkaz ? Thank you, Pam ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [November 14, 2023, 5:50am UTC](https://community.hubspot.com/t/email-report-by-individual-email-send-date-without-empty-dates-or-aggregation/93889/3 "2023-11-14T05:50:07Z")
Hi @karenkaz, If your ask is whether you can remove the 0s from this report… > * * * > > @karenkaz wrote: ![daily.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/3/c3ddf1c7b4c43ef5f9ae68d534dee1d91c611532.png) > * * * … then as far as I know, that’s not possible. I’d also argue that – while this could be nicer to look at – it’s not obstructing the view on the relevant data. It’s a limitation by HubSpot but acceptable. If you want better customization options for this type of report, I’d recommend requesting them in the HubSpot Ideas section of the community: [https://community.hubspot.com/t5/HubSpot-Ideas/idb-p/HubSpot\_Ideas](https://community.hubspot.com/t5/HubSpot-Ideas/idb-p/HubSpot_Ideas) The product team reviews these requests based on their popularity. Best regards! ---
**Author:** ![JSmith94](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jsmith94/32/195285_2.png) [@JSmith94](https://community.hubspot.com/u/JSmith94)\ **Post date:** [February 6, 2024, 1:38pm UTC](https://community.hubspot.com/t/email-report-by-individual-email-send-date-without-empty-dates-or-aggregation/93889/4 "2024-02-06T13:38:46Z")
I want to do exactly the same thing. I find it so frustrating that it’s not possible. Here’s my bar chart (below). We run training courses, and so I’ve put the date of the training course on the X-axis. The courses are every quarter or so, so most of the year there is nothing happening - just a few dates a year. ![Screenshot 2024-02-06 at 13.25.56.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/3/53096e3722ffcff68199c216b01aa1f3d2906387.png)