6 Replies Latest reply: Aug 2, 2016 3:48 AM by Marc van der Peet RSS

    Graph with calculated dimension does not show data

    Marc van der Peet

      Dear all,

       

      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?