Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Subscribe

I am using SAP cloud analytics to find the average profit by region using a calculated measure. However it does not show the average but only the sum.  I chose Average for operation and Aggregation Dimension as Region. See screenshot. The chart for Aggregation shows sum instead of average. Please advise. Thanks 

Abraham3_0-1734463518065.png

 

0 Likes

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
View Entire Topic
ramkumar_thayumanavan
Explorer
‎2024 Dec 18 11:15 AM

Hi @Abraham3 ,

Good day!!

Averaging between region will give you only single value(which is the average amount considering all the regions). So when you again add the region dimension to the chart it will any way split to individual values.

You must remove the region dimension in the chart to get the average.

Or if you want the split of regions you should be aggregating based on other dimensions.

Kind regards,

Tha.Ram

Show replies
Show replies
Abraham3
Explorer
‎2024 Dec 18 3:02 PM
0 Likes

Thanks for the update @ramkumar_thayumanavan . I tried but I am still not able to see average by region. This is the superstore data https://community.tableau.com/s/question/0D54T00000CWeX8SAL/sample-superstore-sales-excelxls. I am trying to create a bar chart that shows average profit of each region. Please let me know how I can create a bar graph that shows each the region and the average profit. Thanks

Ask a Question