1 Reply Latest reply: Sep 27, 2012 1:22 PM by Stefan Wühl RSS

    compare the development of currencies in one line chart

      Hej,

       

      I would like to compare the development of currencies in one line chart. i have historical data available:

       

      Date | EUR.USD | EUR.GBP | EUR.AUD

       

      My idea was to use the function "firstSortedValue" like this in my formulas for all the three formulas:

       

      EUR.USD/firstSortedValue(EUR.USD)

       

      But this approach does not work. No data shown.

       

      What am I doing wrong?

       

      Thank you for your help,

      Sebastian

        • Re: compare the development of currencies in one line chart
          Stefan Wühl

          Though the HELP says the sort weight is optional (at least this is indicated by the [] brackets), I believe it isn't.

          So you need to give a second argument with the sort weight you want to use.

           

          But maybe there is an easier option, if you're expression values are already sorted by Date (to see the correct development over time) you should be able to address the first value using top() chart inter record function:

           

          = only(EUR.USD) / top( only(EUR.USD))