9 Replies Latest reply: Mar 25, 2014 10:57 AM by Ola Amphan RSS

    Is it possible to divide a solitary datapoint to graph it over a dimension?

    Ola Amphan

      I have a dataset with revenue data spread over the year. In this dataset there is also budget data but that data is not accrued over the year. See the example below. I would like to create a line chart with revenue and budget charted over the months where budget is graphed with sum(budget)/12 every month. Is it possible to do this within the chart expression somehow? Or do I need to work with the data in the script?

       

      LOAD * INLINE [

          month, revenue, budget

          1, 1000, 0

          2, 1200, 18000

          3, 2000, 0

          4, 1700, 0

          5, 1400, 0

          6, 1300, 0

          7, 1500, 0

          8, 1600, 0

          9, 1700, 0

          10, 1800, 0

          11, 1700, 0

          12, 1500, 0

      ];

       

      This is what I have...

       

       

      This is what I want...

       

      TIA

       

      //Ola