# Adding a Sequence Number to Table Visualizations

**URL:** <https://community.amazonquick.com/t/adding-a-sequence-number-to-table-visualizations/1326>\
**Category:** Q&A\
**Tags:** charts, quick-sight\
**Created:** [January 24, 2022, 9:25pm UTC](https://community.amazonquick.com/t/adding-a-sequence-number-to-table-visualizations/1326 "2022-01-24T21:25:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ugadawg90](https://avatars.discourse-cdn.com/v4/letter/u/4af34b/32.png) [@ugadawg90](https://community.amazonquick.com/u/ugadawg90)\
**Post date:** [January 24, 2022, 9:25pm UTC](https://community.amazonquick.com/t/adding-a-sequence-number-to-table-visualizations/1326/1 "2022-01-24T21:25:07Z")

</div>

Does anyone now how to add a row number sequence to a Table visualization? Essentially it would be like an Excel row number starting at 1 and ending with the number of results in the visualization

Row Value  
1 String1  
2 String2  
3 String3

---

<div class="post-metadata">

**Author:** ![Akhil](https://avatars.discourse-cdn.com/v4/letter/a/7ab992/32.png) [@Akhil](https://community.amazonquick.com/u/Akhil)\
**Post date:** [January 24, 2022, 9:40pm UTC](https://community.amazonquick.com/t/adding-a-sequence-number-to-table-visualizations/1326/2 "2022-01-24T21:40:15Z")

</div>

Hi,

To add row numbers, you can leverage a combination of concat and denseRank functions. Include the String and output of denseRank in the concat calculation.

The concat take only string inputs, so you may want to convert the rank output (originally integer) to string using toString(_input_ ) function. Hope that helps.

concat(_expression, expression, expression…_ )  
denseRank(_[sort attribute ASC/DESC, …], [partition by attribute, …], calculation level_ )
