Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
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
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.
I was able to answer my own question via: Filtering in Visualizations using Table Calculations (3.28+) Thanks! Sarah
Here is a better screenshot of the tables. I recreated them in Excel so I could remove sensitive information. Thanks again!
We had a similar duplicate count request, and we used the above steps, however the table is messy. We are currently using the suggested partition_row_number and duplicate count custom fields. We are trying to get a total number of ‘# of reviews’ for each Project ID. Right now, when a project is reviewed more than once the project ID shows up the number of time it was reviewed. An example of what we would like to show is to have the project ID show up on one line with the TOTAL # of reviews on the same line. We are trying to count the number of times a project ID was in Workscope Review. Example of Current Visualization: Project ID Review Review Task Details Task Name # of Reviews 1 Passed Review 1 1 Error Review 2 2 Error Review 1 2
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
