Home » Archived » BIRT » How to set the x-axis order(Having trouble understanding why the x-axis order is out of order)
| How to set the x-axis order [message #748837] |
Mon, 24 October 2011 19:12  |
Eclipse User |
|
|
|
Hello,
Hoping someone can help me out. I want to do a simple line graph which shows the number of cases by month by priority (each priority is it's own line).
I have a simple data set, where I've ordered everything correctly. It is ordered by year, month, priority, and everything displays correctly in sql. The query is:
select count(issueID), year, timeDimension.monthDscShort, month, priority
from issue inner join TimeDimension on (Issue.createdDateTDID=TimeDimension.timeDimensionID) where year>=(EXTRACT(YEAR FROM NOW())-1) group by year, monthDscShort, month, priority order by year asc, month asc, priority asc;
I test the display and order in a table, all is fine. I then go to a line graph. I put the count on the y axis, and the year + month on the x-axis. I then put the priority in the "Optional Y series Grouping" The data displays, but the ordering is all off and is not displaying numerically. I'm guessing the grouping is somehow screwing this up. Can anyone give me any pointers or points me to documentation I can read to help me figure this out?
I played around with the SortKey in the definition, but it didn't help at all. I have attached a screenshot of my design, the output, and the file itself.
[Updated on: Mon, 24 October 2011 19:12] by Moderator |
|
|
| Re: How to set the x-axis order [message #750068 is a reply to message #748837] |
Tue, 25 October 2011 12:01  |
| Eclipse User |
|
|
|
Have you tried removing the optional grouping and click the group sort
icon on the x-axis and make it group on priority?
Jason
On 10/24/2011 7:12 PM, Kevin Williams wrote:
> Hello,
>
> Hoping someone can help me out. I want to do a simple line graph which shows the number of cases by month by priority (each priority is it's own line).
>
> I have a simple data set, where I've ordered everything correctly. It is ordered by year, month, priority, and everything displays correctly in sql. The query is:
>
> select count(issueID), year, timeDimension.monthDscShort, month, priority
> from issue inner join TimeDimension on (Issue.createdDateTDID=TimeDimension.timeDimensionID) where year>=(EXTRACT(YEAR FROM NOW())-1) group by year, monthDscShort, month, priority order by year asc, month asc, priority asc;
>
> I test the display and order in a table, all is fine. I then go to a line graph. I put the count on the y axis, and the year + month on the x-axis. I then put the priority in the "Optional Y series Grouping" The data displays, but the ordering is all off and is not displaying numerically. I'm guessing the grouping is somehow screwing this up. Can anyone give me any pointers or points me to documentation I can read to help me figure this out?
>
> I played around with the SortKey in the definition, but it didn't help at all. I have attached a screenshot of my design, the output, and the file itself.
|
|
| | | |
| Re: How to set the x-axis order [message #754606 is a reply to message #754312] |
Thu, 03 November 2011 09:29 |
| Eclipse User |
|
|
|
It should be sorting on the category value. Within each group you can
sort using the sort icon next to the optional grouping field on the
second tab of the chart wizard.
Jason
On 11/1/2011 11:06 PM, Kevin Williams wrote:
> Jason,
>
> Thanks for the example! It helps a lot. Grouping on the x axis sums up
> items by a category, if not summed, which I don't need as I've already
> summarized the data in SQL.
>
> Going back to the sorting, when I have the optional y series grouping
> selected, the "sort on" sorting option field is grayed out, and forced
> to be the display name. Can you explain why I can't set the sort order
> when I use the optional y series Grouping?
>
>
>
|
|
|
Goto Forum:
Current Time: Wed Jul 23 14:41:54 EDT 2025
Powered by FUDForum. Page generated in 0.03636 seconds |
Home
