Grouping on id @ chart level

[Anonymous]

Hi All,

I need to group my P_id column on bar chart,plz help.

How we can do that

Thanks

Manish Madan

[MK_QSL]

Grouping of ID means?

Can you elaborate little more please ?

[shree909]

For Grouping use the AGGR function in ur expression..

[Anonymous]

Hey Manish,

Requirement:i have a stacked bar Chat in this i have to display Zone  and respected Self ratings and graph should change on selection of Model,Entity,competency,component,behaviour.

Problem:graph is not changing for Competency and component.

Thanks for your help in advance

Please find attached .qvw file

Thanks

Manish Madan

[jagan]

Hi,

I think the issue is with your data, for every participant ID and zone you are having the Competency Model and Component Name.  That is why even when you select Competency Model and Component Name the chart data is not changing.  If you use sum(bnn_score) then you can see the difference.

Regards,

Jagan.

[Anonymous]

Hi Jagan,

For every selection on Competency or Component name have different number of rows,it should change,moreover they have different ratings as well...so change should happened..but i don't know what is stopping it for changing the graph or i am using any wrong way to reflect these changes.

Thanks

Manish Madan

[sasikanth]

hi

if you ibserve in your data model ,

it seems there is no link between ZONE and Component name ,

for any selection of Component name there are no associated values in ZONE,

That is only creating problem, for clarity remove zone from chart and check selections are going on

[Anonymous]

Hi All,

I got the reason behind it is not changing the data

here it is:if i select any competency or component name or any combination of both each of component and competency have a 3066 ( participant ID + Zone ) combination which is set total number of unique records.due to that every selection is returning the same combination and displaying the Zone level data which result into same output as it is showing.

Zone level also i have total 3066 records.

I tried changing the participant Id in source and i can see the variations are happening in Chart on selection of competency and component.

Thank you so much all for you efforts, i really appreciate that.

BR,

Manish madan

[Anonymous]

Hi Shasikant,

Actually i have to display the variation in data at Zone level itself.

Thanks

Manish Madan