Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 312679

Summary: Optional y Axis and data from Container With Groups
Product: z_Archived Reporter: Scott Rosenbaum <scottr>
Component: BIRTAssignee: Xingsheng Zhu <xzhu>
Status: VERIFIED FIXED QA Contact: Xiaoying Gu <bluesoldier>
Severity: major    
Priority: P3 CC: bluesoldier, jasonweathersby, liheeng, Lionel.wyl
Version: 2.5.2   
Target Milestone: 2.6.2   
Hardware: PC   
OS: Windows 7   
Whiteboard: Obsolete
Attachments:
Description Flags
Report Design demonstrating problem
none
group list
none
context menu none

Description Scott Rosenbaum CLA 2010-05-12 14:18:16 EDT
Created attachment 168219 [details]
Report Design demonstrating problem

If you are using a chart with data from a container, and you want to use the optional y-axis, you can not use the "Inherit Columns and Groups".  In other words you can't let the table do the aggregation and have the chart use it for the Optional Y-Series Grouping.

I have attached a report that demonstrates this.

I tried using three different fields in the Optional-Y Series Grouping.  None of them worked:

 - grpYear (this is what I think should work)
 - ORDERDATE (does not work)
 - yearValue (does not work)
Comment 1 Scott Rosenbaum CLA 2010-05-12 14:20:29 EDT
Yes, I realize that you can work around the problem by not using the Inherit Columns Only and then letting the chart do the grouping, but that kind of goes against the spirit of having Inherit Columns and Groups.

So if it is supported then, you should probably use a second group value in the Optional Y-Series Grouping field.

If it is not supported, then the Optional Y-Series should be disabled when using Inherit Columns and Groups.
Comment 2 Xingsheng Zhu CLA 2010-11-05 02:39:41 EDT
Disable the optional grouping composite for chart which inherits groups. Existing query of optional grouping will be shown on UI and can be cleared by user.
Comment 3 Xiaoying Gu CLA 2010-11-05 02:42:45 EDT
Verified in daily build 20101105 that UI was disabled.
Comment 4 Heng Li CLA 2011-01-26 03:15:12 EST
Hi Scott, 
I am sorry that we have rollbacked previous changes for this bug. Actually, this is not a bug. Because for 'Inherit Columns & Groups' case, it is like 'chart sharing table' case, not all expressions of table could be used as Optional Y group of chart, if the group number on table is more than two, the top group of table is allowed to be used as Option Y group of chart. In your attached report, the top group of table is grpProductLine, only it can be used as Optional Y group. We also provide group list for Optional Y
group and context menu for data preview component to indicate which expressions
could be used for Optional Y group in chart builder dialog, please refer attached screenshots. So the Optional Y group UI shouldn't be disabled. The correct situation is that you just can use grpProductLine expression for Optional Y group in 'Inherit Columns & Groups' case, can't use other expressions.
Comment 5 Heng Li CLA 2011-01-26 03:26:28 EST
Created attachment 187614 [details]
group list
Comment 6 Heng Li CLA 2011-01-26 03:27:01 EST
Created attachment 187615 [details]
context menu
Comment 7 Heng Li CLA 2011-01-26 22:58:31 EST
Hi Scott,
I re-investigated this issue, and found the problem you mentioned is existing under a special case. The case is, if user select 'Inherit Columns & Groups' in chart and now there are no groups in table, the Optional Y group UI should be disabled. The reason is chart can't do group by itself under this case and table also doesn't do group, so chart can't add Optional Y group. I have revised UI logic for above issue in the latest check-in.
Thanks.