
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Average for each Function - Bar graph
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 |


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Its correct whatever I've mentioned in the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See here the value, Also see the measure which I've used.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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];
