1 Reply Latest reply: Jun 6, 2016 12:01 PM by Gysbert Wassenaar RSS

    Combo Chart : compare 2 measures

    annick whitfield

      Hello,

       

      In a combo chart, I would like to compare the sales amount with the target sales amount either per month or per city, for the current year.

       

      Here's my load script:

      Sale:
      Load * inline
      [
      SaleID, SaleAmount, SaleYear, SaleMonth, SaleCity, SaleDay
      101,     100,                2016,       1,                PAR,       10
      102,      10,                 2016,       1,                LON,       11
      103,      150,               2016,      3,                 HEL,        9
      104,      210,               2016,      4,                 FRA,       2
      105,      40,                 2016,      4,                 PAR,     13
      106,      345,               2016,      8,                 LON,     21
      107,      35,                 2016,      8,                 FRA,     25
      ];


      Target:
      Load * inline
      [
      TargetYear, TargetMonth, TargetCity, TargetAmount
      2016,  1,    PAR,  20
      2016,  1,    LON,  30
      2016,  2,    PAR,  10
      2016,  2,    LON,  20
      2016,  5,    HEL,  15
      2016,  6,    PAR,  10
      2016,  6,    LON,  20
      2016,  7,    PAR,  15
      2016,  8,    PAR,  20
      2016,  9,    HEL,  15
      2016,  10,    HEL,  5
      2016,  11,    HEL,  0
      2016,  12,    PAR,  15
      2016,  12,    LON,  25

       

      ];

       

      Here's my combo chart with :

      • Dimension : SaleMonth
      • Measure: Sum( {$<SaleYear = {'2016'}>} SaleAmount)

       

      In the same graph I would like to add a second measure which is the sum of the TargetAmount for SaleMonth = TargetMonth and TargetYear = 2016.

      Is there an efficient way to achieve this in the UI without changing the load script (I don't want to rename the fields and I want to avoid synthetic keys...)?

       

      Many thanks.

      Annick