Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Running count not based on a table column

Hi,   I would like to place a running count column on a table visual, that has a value starting from 1 on the first row and incrementing by 1 for each following row.  I know I can do this based on a...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi Anonymous ,

     

    I don't think what you're trying to achieve is possible.  For a sequence to work, it must reference a column and changing the order of rows in such a column would result to your sequence changing as well.

danextian's avatar
danextian
Super User
2 years ago

Hi Anonymous ,

 

Please post a usable  sample data (not an image) and your expected result from that.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Danextian,

      Here's the data:

     

    PlayerIdLastNameFirstNameCountryDescription
    11SmitHansUSA
    20PowersJesUSA
    33SmithyEllenMexico
    40ValonDeborahMongolia
    50PalmersJaniceUSA
    119TaddyDwight

    USA

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      And here is the visual:

       

      The data was not sorted.  Note, I don't care if it is sorted or not, but I want the Running Count row to be in ascending sequential order, starting from one.  That regardless of the sort or filter.  Thanks.

      • danextian's avatar
        danextian
        Super User
        2 years ago

        Hi Anonymous ,

         

        I don't think what you're trying to achieve is possible.  For a sequence to work, it must reference a column and changing the order of rows in such a column would result to your sequence changing as well.