Hide row in html table if column data is empty
We have a business rule where we only show data if the number of rows is
>=7 because of privacy/pii concerns, and we do that with a beast mode calculation, and apply it as filter
CountRespondents: SUM(COUNT(DISTINCT `ratingid`)) OVER ()
But when I want to filter/hide the rows where the Comment is empty, the CountRespondents value decreases too. I set the filter to
>=4 in this screenshot:
Is there a way to hide the data instead of filtering?