Line Chart value changes on selection

[#1]

Hi Experts,

I have created a line chart with month as dimension and used aggr() function in expression.

The line chart is giving the correct value but it changes on selection of month and showing wrong value.

Regards,

Anjali Gupta

[Mark_Little]

Hi,

Is it possible to supply some more information or a sample Qvw?

What is the expression?

What are you seeing?

What are you expecting to see?

Mark

[#3]

Hi Anjali ,

can u share what wrong values your are getting detail

[#4]

Hi Mark,

    Before any selection the line chart has the value :

May : 100.00%

Sep : 99.95%

Oct  : 99.97%

whereas on selecting the month as Sep the value of Sep changes from 99.95% to 99.97%

Below is the image:

Expression Used: 

=Avg(Aggr(

Num( 1-(Num(sum(field1))

/(Interval(MonthEnd( [Year-Month]))-MonthStart(min([Year-Month])),'mm'))),'##.###%'))

,Field2))

Due to some restriction I can't share the field1's and field2's exact name.