Add a row number in cards using table chart

Reply
Highlighted
White Belt

Add a row number in cards using table chart

Hi! has anyone being able to add the rownumber on a table chart ? 

 

Highlighted
Brown Belt

Good morning, 

Unfortunatley there isn't a way to have a table display numbers for the rows. However, depending on how you want your data numbered and ordered in the table you could add a rank to the dataflow.

 

https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Rank_or_Row_Count

Highlighted
Red Belt

@user045760 

You can actually use a windowed function beast mode assuming your have unique identifiers in each row.

 

This example is using the Date Dimension but you could change `Date` to your key field(s)

SUM(SUM(1)) OVER(ORDER BY `Date`)

You may need to have your CSM enable windowing functions as I believe it's still in beta.



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.