Count Number of VISIBLE Rows in a Table


(Sarah) #1

I am working with a table where I used multiple yes/no formulas to hide specific rows. Now that those rows are hidden, I would like the number of rows that remain as a Single Value for my Dashboard. Is there a way to get the table to count only the VISIBLE rows?
Thank you!
Sarah


(quinn.morrison) #2

Hi Sarah,

Thanks for reaching out! In order to count only the rows that are visible (because they evaluate to Yes in your table calc), we should be able to create another calculation like this:

count(if(${table_calc_name} = yes, 1, 0))

This should count only the rows that evaluate to Yes and are visible. We can then hide all rows except this new table calc in order to display it as a single value visualization.

Let me know if that works for you!

Quinn


(Sarah) #3

Hello Quinn,
I used that formula, however all of the rows are still being counted, and I am not sure why.
Here is the formula I am using: count(if(${project_id_change_calculation_2_1}=yes,1,0))
I would expect the count to be 37, but I am getting 407 which is all the rows in the table.
I have attached a modified version of the table I am working with as there was some sensitive information I had to remove.


(quinn.morrison) #4

Hi Sarah!

Can we actually try wrapping that in a sum() rather than a count()? That should add up only the 1’s–if we were to use a count() function, we would change the output to (1, null).

Let me know how that works!


(Sarah) #5

Good morning Quinn,
Changing the formula from COUNT to SUM worked! Thank you so much for your help!
Enjoy the rest of your week!
Sarah