Share your product feedback

Add a new idea Subscribe
Status Already exists
Categories Reports
Created by Guest
Created on Feb 15, 2017

RELATED IDEAS

Show release month as "January" rather than "2017-01" in pivot report

When showing the release month in a pivot report, it appears in the form "2017-01" rather than "January".  This makes the table more difficult to read and equate with real months as people know them.

  • ADMIN RESPONSE
    Sep 5, 2024

    Thank you for the idea. This is possible today by creating a calculation column in a list report and using it in your pivot report. The status of this idea was out of date.

    Steps:

    1. Create a release list report with the release date

    2. Add a new calculation column to your list report

    3. Enter in the formula bar: dateformat(field("Release date"),"%B")

    4. The column will display the month of the release date as January, for example

    You can learn more on data functions here: Custom equation functions and operators > Date functions


    Calculation col...
    Calculation column dateformat.png
    Open full size
    Calculation column dateformat.png
  • Attach files
  • Olivia Quakenbush
    Reply
    |     Jan 7, 2021

    It would also be nice to have a choice on how the date format was to display.

  • Olivia Quakenbush
    Reply
    |     Jan 7, 2021

    I agree, the date would be so much easier to read if it were text.

Idea management by Aha!
Create your own ideas portal to crowdsource feedback
© 2024 Aha! Labs Inc.•All rights reserved