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.