If one of the "coding masters" in this forum could assist me, I would be very appreciative. I have wasted an extrodinary amount of time trying to do something that should be exceedingly simple. I want to chart out some very simple data. Employess have pagers and get called out to work. My boss wants several charts. Call out by month. Call out by day of week. Call out by Time of day (Three shifts days afternoons and midnights). Problem is, the charts insist on displaying alphabetically. I have fforced one of the charts to list chronologically. However, the remaining charts refuse to list that way.
Any help would be appreciated.
For the chart that works now I added a column and input:
Switch([month]="January",11,[month]="February",12,[Month]="March",13,[Month]="April",14,[Month]="May",15,[Month]="June",16,[month]="July",17,[month]="August",18,[Month]="September",19,[Month]="October",21,[Month]="November",22,[Month]="December",23)
However, if I do the same thing for my "day of the week" chart, it won't work.
WHY!!!
Any help would be appreciated.
For the chart that works now I added a column and input:
Switch([month]="January",11,[month]="February",12,[Month]="March",13,[Month]="April",14,[Month]="May",15,[Month]="June",16,[month]="July",17,[month]="August",18,[Month]="September",19,[Month]="October",21,[Month]="November",22,[Month]="December",23)
However, if I do the same thing for my "day of the week" chart, it won't work.
WHY!!!
