Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » RE:Ordering text Day of week correctly on x axis((Problems getting graphs right))
RE:Ordering text Day of week correctly on x axis [message #685685] Sat, 18 June 2011 00:56 Go to next message
Chris  is currently offline 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: RE:Ordering text Day of week correctly on x axis [message #685970 is a reply to message #685685] Tue, 21 June 2011 03:28 Go to previous messageGo to next message
Tomas Greif is currently offline Tomas Greif
Messages: 53
Registered: September 2010
Member
Hi, you need to add sorting by "orderdayno" to your chart.
Tomas
Re: Ordering text Day of week correctly on x axis [message #686122 is a reply to message #685685] Mon, 20 June 2011 10:44 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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


Jason Weathersby

BIRT Exchange
Re: Ordering text Day of week correctly on x axis [message #686305 is a reply to message #685970] Tue, 21 June 2011 21:17 Go to previous message
Chris  is currently offline Chris
Messages: 47
Registered: September 2010
Member
Thanks Thomas and Jason,
I thought that there had to be a sort field somewhere, but I could not find it.
Chris
Previous Topic:Want to see the enhancements you need in the next BIRT release? Vote for them!
Next Topic:Documented changes to font sizes?
Goto Forum:
  


Current Time: Fri Apr 18 14:26:45 EDT 2014

Powered by FUDForum. Page generated in 0.06452 seconds