# How to sort reports data by date

**URL:** <https://community.hubspot.com/t/how-to-sort-reports-data-by-date/130298>\
**Category:** Dashboards & Reporting\
**Tags:** reports, marketing-email\
**Created:** [April 22, 2025, 2:20pm UTC](https://community.hubspot.com/t/how-to-sort-reports-data-by-date/130298 "2025-04-22T14:20:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![AMoss5](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@AMoss5](https://community.hubspot.com/u/AMoss5)\
**Post date:** [April 22, 2025, 2:20pm UTC](https://community.hubspot.com/t/how-to-sort-reports-data-by-date/130298/1 "2025-04-22T14:20:24Z")

</div>

Hi,

I’m trying to create a report that shows email metrics (open rate and CTR) for our different email campaigns. My y-axis is the email open rate/CTR, and the x-axis is the name of the email, but I can’t figure out how to add the email Send Date field (which is offered as an option for the axes) to the report so I can sort the x-axis by that date. I don’t want to display the date in the report, but instead sort the x-axis by the date.

When clicking on the pencil next to the email name in the x-axis, the sort dropdown won’t show me Send Date as an option.

Is there a different way to do this?

 ![image.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/6/26922e91e2325b00a58210aca0ccd1281d1f3e9d.png)

Thank you!

---

<div class="post-metadata">

**Author:** ![warrendavey](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/warrendavey/32/34525_2.png) [@warrendavey](https://community.hubspot.com/u/warrendavey)\
**Post date:** [April 22, 2025, 3:12pm UTC](https://community.hubspot.com/t/how-to-sort-reports-data-by-date/130298/2 "2025-04-22T15:12:48Z")

</div>

@AMoss5 - I tried taking a try at solving your problem. Here is a recording I made of my solution for you. Please let me know if you have any questions or if there’s more context you’d like to provide.

[![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/d/9d8f5b4bf6c4cff9a6f21162c573edeb39f9d5e6.jpeg "Answering HubSpot Reporting Questions") ](https://www.youtube.com/watch?v=oi7YvtajZDw)

---

<div class="post-metadata">

**Author:** ![Jaycee\_Lewis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaycee_lewis/32/61352_2.png) [@Jaycee\_Lewis](https://community.hubspot.com/u/Jaycee_Lewis)\
**Post date:** [April 22, 2025, 3:26pm UTC](https://community.hubspot.com/t/how-to-sort-reports-data-by-date/130298/3 "2025-04-22T15:26:00Z")

</div>

Hey @warrendavey 👋 Thanks for taking the time to create that video! The auto-filter grabbed it, but we should be good to go now. — Jaycee

---

<div class="post-metadata">

**Author:** ![AMoss5](https://avatars.discourse-cdn.com/v4/letter/a/54ee81/32.png) [@AMoss5](https://community.hubspot.com/u/AMoss5)\
**Post date:** [April 22, 2025, 4:14pm UTC](https://community.hubspot.com/t/how-to-sort-reports-data-by-date/130298/4 "2025-04-22T16:14:13Z")

</div>

Hi @warrendavey thank you so much for the detailed video response!

You understood my problem correctly, in that I just want to sort the emails in the x-axis by the value in that email’s send date, but I don’t need to display the dates in the actual report. Just sort.

I followed your direction and applied the Send Date as a filter. So now I have a filter for Send Date is known, but it didn’t affect the order of the x-axis in any way. Did I miss a step to make it auto-filter?

 ![image.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/f/1/f17a5e747427f04e7a8dace7d6933f9edf791f62.png)

Thank you!