1 of 1 people found this helpful
I partially understood your request, but could you specify how you want to aggregate these Object Type?
Count?, Min ? Max? Sum? using which grouping Session ID? date? ......
What I really wanted is to get the result of the table calculation and aggregated it by Object Type so I only have 3 bars
I attached a case of sum.
I am trying to calculate the Average for these Object Types
I checked your suggested solution and it is correct thanks. I also was able to get the Average Aggregation. My next question is if there is a way to make my Avg aggregation to be a running total so I can prepare a waterfall chart instead of a normal bar chart.
Can you open another thread for the other question it would be easy for others to look into the problem.
As Tharashasank says, it seems like there need another more detail specification how you want to create water fall charts.
1. what is previous
2. what is current
3. what is the breakdown in between.
Here is some examples of waterfall charts but the requirement is always little bit different