Skip to main content



      Home
Home » Archived » BIRT » Chart - Bar - Optional Y Series Grouping - Sorting
Chart - Bar - Optional Y Series Grouping - Sorting [message #367525] Thu, 19 March 2009 10:16 Go to next message
Eclipse UserFriend
Originally posted by: alexandre.petit.jaree.com

Hi,

In "Edit Chart", I want to sort my "Optional Y Series Grouping".
I know that we can do it by clicking "Group and sorting" and "Data
Sorting" but we have just the choice between "Ascending" and "Descending".

My problem is that I have 3 choices:
- Yes
- No
- Neutral

And I want them like:
- Yes
- Neutral
- No

Thanks
Alexandre Petit
Re: Chart - Bar - Optional Y Series Grouping - Sorting [message #367573 is a reply to message #367525] Mon, 23 March 2009 10:40 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: alexandre.petit.jaree.com

Has anyone an idea?

Is there a way or do I need to "change" my database.
Something like
- Yes = 1 - Yes
- No = 3 - No
- Neutral = 2 - Neutral

Alexandre Petit wrote:
> Hi,
>
> In "Edit Chart", I want to sort my "Optional Y Series Grouping".
> I know that we can do it by clicking "Group and sorting" and "Data
> Sorting" but we have just the choice between "Ascending" and "Descending".
>
> My problem is that I have 3 choices:
> - Yes
> - No
> - Neutral
>
> And I want them like:
> - Yes
> - Neutral
> - No
>
> Thanks
> Alexandre Petit
Re: Chart - Bar - Optional Y Series Grouping - Sorting [message #367590 is a reply to message #367573] Tue, 24 March 2009 12:18 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: alexandre.petit.jaree.com

Ok, I have been changing my input Database.
So no I am with "1 - Yes"...
I have been happy because now I can sort "Optional Y Series Grouping" in
the chart.

But now I want to map my "1 - Yes" into "Yes".
I know how to do it in a cell or a table: just go to "Map List" and then
make a condition. I can't find it for a chart.

So I have been making some grid to make my "Map List" but the chart
doesn't care.

Do you have any idea?

NB: "Select Data" in the chart is "Inherit Data from Container", so it
should work.


Alexandre Petit wrote:
> Has anyone an idea?
>
> Is there a way or do I need to "change" my database.
> Something like
> - Yes = 1 - Yes
> - No = 3 - No
> - Neutral = 2 - Neutral
>
> Alexandre Petit wrote:
>> Hi,
>>
>> In "Edit Chart", I want to sort my "Optional Y Series Grouping".
>> I know that we can do it by clicking "Group and sorting" and "Data
>> Sorting" but we have just the choice between "Ascending" and
>> "Descending".
>>
>> My problem is that I have 3 choices:
>> - Yes
>> - No
>> - Neutral
>>
>> And I want them like:
>> - Yes
>> - Neutral
>> - No
>>
>> Thanks
>> Alexandre Petit
Re: Chart - Bar - Optional Y Series Grouping - Sorting [message #367660 is a reply to message #367590] Mon, 30 March 2009 11:13 Go to previous messageGo to next message
Eclipse UserFriend
How about just creating a computed field and using that?

Scott

Alexandre Petit wrote:
> Ok, I have been changing my input Database.
> So no I am with "1 - Yes"...
> I have been happy because now I can sort "Optional Y Series Grouping" in
> the chart.
>
> But now I want to map my "1 - Yes" into "Yes".
> I know how to do it in a cell or a table: just go to "Map List" and then
> make a condition. I can't find it for a chart.
>
> So I have been making some grid to make my "Map List" but the chart
> doesn't care.
>
> Do you have any idea?
>
> NB: "Select Data" in the chart is "Inherit Data from Container", so it
> should work.
>
>
> Alexandre Petit wrote:
>> Has anyone an idea?
>>
>> Is there a way or do I need to "change" my database.
>> Something like
>> - Yes = 1 - Yes
>> - No = 3 - No
>> - Neutral = 2 - Neutral
>>
>> Alexandre Petit wrote:
>>> Hi,
>>>
>>> In "Edit Chart", I want to sort my "Optional Y Series Grouping".
>>> I know that we can do it by clicking "Group and sorting" and "Data
>>> Sorting" but we have just the choice between "Ascending" and
>>> "Descending".
>>>
>>> My problem is that I have 3 choices:
>>> - Yes
>>> - No
>>> - Neutral
>>>
>>> And I want them like:
>>> - Yes
>>> - Neutral
>>> - No
>>>
>>> Thanks
>>> Alexandre Petit
Re: Chart - Bar - Optional Y Series Grouping - Sorting [message #367697 is a reply to message #367660] Wed, 01 April 2009 08:52 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: alexandre.petit.jaree.com

Found that:
http://www.birt-exchange.com/devshare/designing-birt-reports /590-chart-script-example-of-modifying-series-entries-in-the -legend/#description
Will try it later.

Alexandre

Scott Rosenbaum wrote:
> How about just creating a computed field and using that?
>
> Scott
>
> Alexandre Petit wrote:
>> Ok, I have been changing my input Database.
>> So no I am with "1 - Yes"...
>> I have been happy because now I can sort "Optional Y Series Grouping"
>> in the chart.
>>
>> But now I want to map my "1 - Yes" into "Yes".
>> I know how to do it in a cell or a table: just go to "Map List" and
>> then make a condition. I can't find it for a chart.
>>
>> So I have been making some grid to make my "Map List" but the chart
>> doesn't care.
>>
>> Do you have any idea?
>>
>> NB: "Select Data" in the chart is "Inherit Data from Container", so it
>> should work.
>>
>>
>> Alexandre Petit wrote:
>>> Has anyone an idea?
>>>
>>> Is there a way or do I need to "change" my database.
>>> Something like
>>> - Yes = 1 - Yes
>>> - No = 3 - No
>>> - Neutral = 2 - Neutral
>>>
>>> Alexandre Petit wrote:
>>>> Hi,
>>>>
>>>> In "Edit Chart", I want to sort my "Optional Y Series Grouping".
>>>> I know that we can do it by clicking "Group and sorting" and "Data
>>>> Sorting" but we have just the choice between "Ascending" and
>>>> "Descending".
>>>>
>>>> My problem is that I have 3 choices:
>>>> - Yes
>>>> - No
>>>> - Neutral
>>>>
>>>> And I want them like:
>>>> - Yes
>>>> - Neutral
>>>> - No
>>>>
>>>> Thanks
>>>> Alexandre Petit
Re: Chart - Bar - Optional Y Series Grouping - Sorting [message #367702 is a reply to message #367697] Wed, 01 April 2009 12:43 Go to previous message
Eclipse UserFriend
Originally posted by: alexandre.petit.jaree.com

OK, so I have this problem.
I am not using three different Y - Series.
But just one.

I am currently using a .csv as database.
So my first problem was I couldn't order Yes No Neutral properly (Yes
then Neutral then No).

So I "changed" the input data as "Yes" = "1 - Yes".
(I know this is not well done, but I am testing all that we can do on
BIRT for the moment). But now in my chart the Legend is set:
1 - Yes
2 - Neutral
3 - No
And I need to have Yes, Neutral, No.


Alexandre Petit wrote:
> Found that:
> http://www.birt-exchange.com/devshare/designing-birt-reports /590-chart-script-example-of-modifying-series-entries-in-the -legend/#description
>
> Will try it later.
>
> Alexandre
>
> Scott Rosenbaum wrote:
>> How about just creating a computed field and using that?
>>
>> Scott
>>
>> Alexandre Petit wrote:
>>> Ok, I have been changing my input Database.
>>> So no I am with "1 - Yes"...
>>> I have been happy because now I can sort "Optional Y Series Grouping"
>>> in the chart.
>>>
>>> But now I want to map my "1 - Yes" into "Yes".
>>> I know how to do it in a cell or a table: just go to "Map List" and
>>> then make a condition. I can't find it for a chart.
>>>
>>> So I have been making some grid to make my "Map List" but the chart
>>> doesn't care.
>>>
>>> Do you have any idea?
>>>
>>> NB: "Select Data" in the chart is "Inherit Data from Container", so
>>> it should work.
>>>
>>>
>>> Alexandre Petit wrote:
>>>> Has anyone an idea?
>>>>
>>>> Is there a way or do I need to "change" my database.
>>>> Something like
>>>> - Yes = 1 - Yes
>>>> - No = 3 - No
>>>> - Neutral = 2 - Neutral
>>>>
>>>> Alexandre Petit wrote:
>>>>> Hi,
>>>>>
>>>>> In "Edit Chart", I want to sort my "Optional Y Series Grouping".
>>>>> I know that we can do it by clicking "Group and sorting" and "Data
>>>>> Sorting" but we have just the choice between "Ascending" and
>>>>> "Descending".
>>>>>
>>>>> My problem is that I have 3 choices:
>>>>> - Yes
>>>>> - No
>>>>> - Neutral
>>>>>
>>>>> And I want them like:
>>>>> - Yes
>>>>> - Neutral
>>>>> - No
>>>>>
>>>>> Thanks
>>>>> Alexandre Petit
Previous Topic:Force page break via scripting?
Next Topic:Create Table and SubTable fm CSV Data Source...
Goto Forum:
  


Current Time: Fri Sep 26 05:44:09 EDT 2025

Powered by FUDForum. Page generated in 0.05941 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top