Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Yes the expression looks absolutely right to me. Do you have calculated dimensions? What state is your chart object?
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
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
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
For this scenario, I would check if your chart is in group alternate state?
i did check that ,the chart is in Inherited state
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