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.
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.
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.
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.
.png "sasikanth"){kind=avatar}
