16 Replies Latest reply: Mar 1, 2017 10:37 AM by Sunny Talwar RSS

    Expressing measure the refers to values from different row of table

    Øystein Kolsrud

      Hi! I have the following table:

       

      Key
      Entry
      0x
      1x
      2x
      1y
      2y

       

      Now I want to create a visualization that contains the number of entries per Index as well as the number of entries for the previous index, so the result should look like this:

       

      KeyEntries for Key
      Entries for previous Key
      010
      121
      222

       

      The measure for the first measure I could easily define like this:

       

      COUNT(ENTRY)

       

      But I am having a very hard time expressing the second one. How would I express that measure?