1 Reply Latest reply on Aug 29, 2017 1:34 AM by M. van P

    Collapse/aggregate data in Live Connection

    M. van P
      ProductTypeSales
      Chewing gumFood55
      BreadFood120
      ComputersNonFood560
      BicyclesNonFood1200

       

      I have a big dataset, now I want to increase performance of my dashboards so I leave out the Product column (not using it).

      What I get now is:

      TypeSales
      Food55
      Food120
      NonFood560
      NonFood1200

       

      What I actually want is similar to aggregation when doing an extract:

       

      TypeSales
      Food175
      NonFood1760

       

      How to do this for live connection/data?

       

      Is it possible by uploading the new data structure to the server?