where to fit this group in expression

[kunkumnaveen]

Hello All,

i got two calendar boxs with field value date,

one calendar box is normal one and the other one is with group

below is my exp to which i applied group.which mean this exp should only respond when i change date of group calendar box

Num(sum({group}  aggr( avg({group}units), Date,  work, Order )) /sum({group} hrs),'##.000')

but unfortunately it is changing the value even if i select a date from non group calender box,

i think the group has not fit properly in the exp

can any one suggest plz

[sunny_talwar]

Would you be able to share a sample where this isn't working? I don't see anything wrong with the expression and it should only filter based on selections in group state

[kunkumnaveen]

i wish but i am not allow to share any kind of data,

Num(sum({group}  aggr( avg({group}units), Date,  work, Order )) /sum({group} hrs),'##.000')

is it right to have these many groups in the exp.i mean can u suggest any modification in this exp

[sunny_talwar]

Yes the expression looks absolutely right to me. Do you have calculated dimensions? What state is your chart object?

[kunkumnaveen]

NO i dont have  any calculation dimensions,and my chart is in inherited state,

which is right because i am showing non group ,group exp in single table chart

[sunny_talwar]

Unfortunately, I am not sure what might be going wrong. But I can assure you that there is nothing you can do to your expression to make it better

[kunkumnaveen]

ok ,let me reverse this topic,i mean i got a calendar object with Alternative State =group

and a normal exp without any group

Num(sum(  aggr( avg(units), Date,  work, Order )) /sum(hrs),'##.000')

now the problem is when i change a date in calendar object which is with state group it is effecting my above exp

in fact it shouldn't happen .....

can u says y plzzzz

[sunny_talwar]

For this scenario, I would check if your chart is in group alternate state?

[kunkumnaveen]

i did check that ,the chart is in Inherited state

[sunny_talwar]

This is a very strange behavior I have never seen before that a chart in inherited state with no reference to alternate state is getting filtered based on selection in alternate state's selection. I think unless I see the issue, it would be difficult to say much here:

Preparing examples for Upload - Reduction and Data Scrambling