Specifying Chart Labels

[ClanLabCooker]

Version 8.5

My report groups transactions by the day of the week received (1=Sun, 2=Mon, etc.) This information is pulled from a DateTime field with the formula:
DayOfWeek ({LABSUB.Received Date})

The report displays a group header with the text day name showing from the formula:
WeekdayName (DayOfWeek ({LABSUB.Received Date}))

Problem:
The legend and labels on my chart show the day number if the group is based on the first formula. If the group is based on the second formula the day name displays, but the legend and chart are in alphabetical order rather than numberic (or natural) order.

How do I get the display order to be in natural order, but the labels/legend to show the day names?

 

[lbass]

Use the second formula and then in the chart expert, highlight the formula->order->specified order. Use the dropdown to add the weekday names in the order you would like.

-LB