How do folks sort by (alphabetical) month in a report?

The new reporting tool is great, but the grouping feature seems to conflict with sorting. I have already had to build extra columns to show month as a word (i.e., January). Now to sort by months of the year, I am kludging some things that are painful when other tools like Excel have such flexibility (up to a custom sort list).

Has anyone solved for that functionality?

(I will submit an enhancement request)

Dale

Find more posts tagged with

Reports

Accepted answers

Mark S Krebs

I just use a helper column for month number and year and then show the month spelled out in another column. Seems similar to what you're doing

All comments

Mark S Krebs

I just use a helper column for month number and year and then show the month spelled out in another column. Seems similar to what you're doing

Dale Murphy

@Mark S Krebs Agree, our approaches are similar.

For me, even after adding those column(s), the sort is problematic. The tool wants to sort the months alphabetically.

So my numerical column is useful to sort initially, but if I introduce grouping in the report by (alphabetical) month, the sort is overridden by the same "alphabet-month" (i.e., April is first).

The logic make sense (namely, group is performed before sort) which is why a specialized "Custom List" feature is needed. (IMO)

For now, my user group will see years as numbers, and then the report grouped (and sorted) by month-number.

Cheers,

(** my ref: Trad Spend)

Mark S Krebs

Could you do a concatenate which would 1 - January?

Dale Murphy

Mark;

I concatenated a letter instead of a number ... if you use a number the sort is still by alphabet so you still don't get months in the calendar order.

Cheers,

Dale

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.