Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one bar chart and text object. both having same expression, but bar chart shows by Month dimention.
When i click on one month values for both bar chart and text object is same, But when i select two month, it should show average of bar chart two month values to text object. For example in my bar chart aug value is 98.82% and Sep value is 99.17% in text object it should display average of two month .ie 98.995. but it shows 99.33. can you suggest me solution for this?
Try Avg(Aggr(YourExpression,Month)) in the textbox.