Forum Discussion
Count rows in table visual
Hello, how to get the number of rows as the total value in a table visual since the data is from multiple tables? Appreciate any help! Thank you
You can count whatever the primary key on the table is. Like if you have a table that shows customer ID, customer name, order quantity and sales amount, coming from 2+ tables, you would count the customer ID row as that would be what is making the rows unique.
It's kind of hard to get it to show up in a table visual in a way that is visually appealing, because any row count is just going to return 1 on each row before you get to the total at the bottom... sometimes I'll turn off the alternating row color and set the font to white to match the background on the values for that column to make it look slightly less lame... the total will still show in the normal font color.