Alias data labels

[vb6novice]

My CR XI report is a 3D Bar chart showing the number of Help Desk calls by hour of day and day of week. The underlying data has the day of week as an integer: 1 for Sunday, 2 for Monday, etc., so the values that show in the axis on the chart are 1, 2, 3, 4, 5, 6 and 7.

The data includes a field that has the abbreviation for Day of Week, but if I use that as the grouping, the results are sorted by alphabetized day of week (Fri, Mon, Sat, Sun, Thu, Tue, Wed). That's not good for much.

I need to use the day numbers but show the text in the normal order for a week (i.e. Sun, Mon Tue, Wed ... Sat).
How can this be done?

 

[lbass]

I would convert the data to weekdayname by using:

weekdayname(dayofweek({table.date}),true)

"true" will return the 3-day abbreviation. Then use that as your on-change-of field and select->group options->specified order and then enter the daynames in the correct order.

-LB

 

[vb6novice]

Thanks lbass,

I didn't know I could specify a sort order by group. Since my data already had a field with the 3-day abbreviation, I just had to make it the group field and specify an order.