Average for each Function - Bar graph

[Venkatsj]

Hi I have a table as shown below where Function is A,B, C and Value is 1 to 10.

I wanted to create a bar graph where dimension is A, B, C and i want the measure to be average of each function.

I am getting error where for A,B,C i am getting the total average of the entire function as 5.5.  But the graph i am looking for is A=1.5, B= 4.5, C= 8.5. Kindly help me with the expression, Thanks. 

Function    Value

A	1
A	2
B	3
B	4
B	5
B	6
C	7
C	8
C	9
C	10

[Or]

This seems as simple as it gets - use Function as the dimension and avg(Value) as the measure. Is this not the case for some reason?

[Venkatsj]

Hi, I've used that but for some reason all the function in the graph getting same avg as 5.5 which is not correct. 

[Or]

I'd suggest you check your data model. It sounds like it may be different from what you described in your post, with Function and Value not actually being connected.

[Venkatsj]

Its correct whatever I've mentioned in the post. 

[Venkatsj]

See here the value, Also see the measure which I've used. 

[Or]

I can only assume it isn't, because if it was, you'd get the correct behavior.

Load * INLINE [
Function, Value
A, 1
A, 2
B, 3
B, 4
B, 5
B, 6
C, 7
C, 8
C, 9
C, 10];