Jump to content

Row numbers in a Table Visualization

Jim Putnam 2

Recommended Posts

I have a table visualization of rankings across the country up to 500 for Sales people. In a table, I want to filter by state, and report their overall rank among the 500. But I also would like a column of their rank in the state that was filtered. So each row of the table viz would have a dynamic row number based on the filter. Something like:

State Rank Name Overall Rank

1 Jon 23

2 Olivia 50

3 Bort 88

I thought using RowId() in the table directly would work but it still returns its row number from the original table. Is there an in-viz formula to return a table row number like the bold field above

Link to comment
Share on other sites

  • 3 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...