This content has been marked as final. Show 6 replies
I would like to create a graph that shows the amount of order per customer_id and also show the sum of the orders.
For this I have the following dataset:
LOAD * INLINE [
Employee_ID, Customer_id, Order_id, Order_total
1, 11, 6, 12
2, 12, 7, 14
3, 13, 8, 176
4, 14, 9, 12
5, 15, 10, 8
With this data I try to create a bar-chart with the following details:
- An calculated dimension: =Aggr(Count([Order_id]), [Customer_id])
- An expresiion: =Aggr(Sum([Order_total]), [Employee_ID])
When I look at the graph however no data shows up. Any thoughts on what I am doing wrong here?