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 RESPONSESep 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:
Create a release list report with the release date
Add a new calculation column to your list report
Enter in the formula bar: dateformat(field("Release date"),"%B")
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
© 2024 Aha! Labs Inc.•All rights reserved
As this idea was closed, I created a new ticket: https://big.ideas.aha.io/ideas/A-I-9180
This recommended solution doesn't appear to work. E.g. Set up the calculation column in list view, then view in Pivot view. The view only offers an alphabetical sorting, e.g. the year starts with April.
It would also be nice to have a choice on how the date format was to display.
I agree, the date would be so much easier to read if it were text.