Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

Count Number of VISIBLE Rows in a Table

  • 26 December 2018
  • 4 replies
  • 3431 views
S

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

4 replies

quinn.morrison
Rank
Userlevel 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

S

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.

Looker%20Help%20-%20Count%20Num%20VISIBLE%20Rows

quinn.morrison
Rank
Userlevel 2

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!

S

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

Reply


Terms of Service