• When display julian date as Month format, date value with same Month will be considered as same group.

• Support sort result column by a internal order depends on Date format.

  • 10 (the 5th one, day): 1 to 31

  • Fri (the 6th one, day of week ): Monday to Sunday, Mon Tue Wed Thu Fri Sat Sun

  • Jul (the 17th one, month display): January to December, Jan, Feb,...,Dec

  • Q3 (the 19th one, quarter display), Q1 to Q4

  • 2020 (the 8th one, year display): year ascending

• Set user-defined label in output result worksheet with correct date/time format setting.

Above rules will be applied in following tools,

• Pivot Table

• Unstack Columns

• plot_gindexed

• plot_gboxindexed

• plot_bygroup