0 Replies Latest reply: Jul 3, 2013 8:29 AM by andries Bos RSS

    show and compare calculated values in a chart/ graphic widget

    andries Bos

      I would like to show graphical representation of the calculated difference in total of different products.

       

      Incomingoutgoingdifference
      LocationProductDescriptionTonsLocationProductDescriptionTons%in-uit
      amsterdamD4000Incoming prod A11060,8amsterdamD4500Outgoing prod A242150,05945
      amsterdamD4200Incoming prod B162,2amsterdamD4523Outgoing prod B242049,94055
      Totaal1123 Totaal841282

       

       

      Its easy to show in a chart the totals for products for current year, ( = Sum({< Year={$(=Max(Jaar))} >} Receipt.Weight.Kilo))

       

      but the user wants to show :

      1. Difference between all four IN en OUT Products :  (where the % shows in the above tabel)

      2. and  with two different products, the difference for thetwo  outgoing products should be shown. (The coloured % values in the above table is the comparison between D4500/D4523 etc...)

       

      Amoung this example, I have a list of other/ different products to compare in the same way. I have attached a xls ans an example.

       

      What is best practice to show this calculated values in a graphical form. : how to 'filter' the products and what sort of chart/ graphic widget should/could be used to represent these type of calculated values...


      A second challenge is to show these values in time e.g. per week etc...