RE:Ordering text Day of week correctly on x axis [message #685685] |
Sat, 18 June 2011 04:56 |
Chris Messages: 47 Registered: September 2010 |
Member |
|
|
Hi Jason,
I have attached the report as requested.
I am trying to get graphs to show performance by day of week. For readability I need to show the day as monday, tuesday etc not 1, 2, etc.
I have 2 problems
1. How to order the days of the week monday,tuesday,wednesday etc and not alphabetically friday,monday,saturday etc.
I have created a simple report with
a) a table showing the number of orders per day
b) a graph with the day number and so showing data in the correct order
c) a graph with the day of the week description with the data incorrectly ordered.
d) a table showing the number of orders by requirement day
e) a graph comparing the number of orders placed by day compared to the number reqired by day. This was for another exercise. It works and can be ignored. I gather apache does not have a day of week function which returns Monday, Tuesday etc.
Thanks for your help
Chris
|
|
|
|
Re: Ordering text Day of week correctly on x axis [message #686122 is a reply to message #685685] |
Mon, 20 June 2011 14:44 |
|
Chris,
The second chart is easy to fix. Just open the second tab of the chart
wizard and click on the sorting and grouping button located next to the
fx button on the Category axis. Select sort ascending and then choose
row["orderdayno"] as the sort field. What do you want done to the first
chart?
Jason
On 6/18/2011 12:56 AM, Chris wrote:
> Hi Jason,
> I have attached the report as requested.
>
> I am trying to get graphs to show performance by day of week. For readability I need to show the day as monday, tuesday etc not 1, 2, etc.
> I have 2 problems
> 1. How to order the days of the week monday,tuesday,wednesday etc and not alphabetically friday,monday,saturday etc.
>
>
> I have created a simple report with
> a) a table showing the number of orders per day
> b) a graph with the day number and so showing data in the correct order
> c) a graph with the day of the week description with the data incorrectly ordered.
> d) a table showing the number of orders by requirement day
> e) a graph comparing the number of orders placed by day compared to the number reqired by day. This was for another exercise. It works and can be ignored. I gather apache does not have a day of week function which returns Monday, Tuesday etc.
>
>
> Thanks for your help
> Chris
|
|
|
|
Powered by
FUDForum. Page generated in 0.03262 seconds