Jotform Reports: Group dates by month

  • Profile Image
    TREF_forms
    Asked on March 12, 2021 at 01:38 PM

    For date fields in Jotform reports, is possible to group dates by month? If not, can this be submitted as a feature request?

  • Profile Image
    Cecile_A
    Answered on March 12, 2021 at 10:09 PM

    Hello there,

    Please allow me some time to check on this and get back to you with relevant information.

    Thank you.

  • Profile Image
    Cecile_A
    Answered on March 12, 2021 at 10:29 PM

    Thank you for waiting.

    It seems like the dates can be sorted in ascending or descending order only. Let me escalate this as a feature request to our backend team.

    Please note that we can't give an ETA for when this will be implemented. Feature requests depend on the workloads of our developers and popularity among our users. But rest assured that we will inform you via this thread once this feature becomes available.

    For the meantime, you can download your submission as Excel and see the guides below to know how to sort/group your data by month.

    Guides:

    https://excelribbon.tips.net/T009728_Sorting_Dates_by_Month.html

    https://www.ablebits.com/office-addins-blog/2020/04/29/sort-by-date-excel/#sort-by-month

    Let us know if you have any other concerns. Thank you!