Forum Discussion
Hide rows in report that do not contain data point
Hello Community, I am working to display ONLY documents that were never downloaded.
How do I exclude rows in below Table visualization that do NOT have a Document Number?
CONTEXT: I created a new data table called Non_Downloaded_docs = EXCEPT(documents, totaldownloads). However, all of the meaningful document metadata is in another data table called Documents_original. In below table visualization, 'Document Number' comes from Non_Downloaded_docs whereas 'Document Name', 'Type', 'Document Status', 'Classification' come from Documents_original.
2 Replies
Hey Anonymous
To do this, click on your table and go to Visual Level Filters. For Document Type, go to Basic Filtering, then click Select All, then uncheck the blank option. Rows without a document name should be removed from the table. You can also go to Advanced Filtering and select "Is Not Blank", however, this option isn't working for me right now for some reason.
Hope this helps,
Parker