Make Hidden Values Not Affect Visualization

[jreis]

Hello,

Is there a way to display in the final visualization the results without showing duplicates? Basically so the visual ignores the hidden fields when grouping the “destination IPs” but still displays the resulting data?

With the way we set things up, I need to keep the table calculation “hide” and the “principal exclude ip” field in place.

(Red blocks are there to mask our data)

Thank you for any help.

[sam8]

I think you’re really close. If you click on the gear on the Hide table calculation, do you see the option “Hide Nos from visualization”? That should do what you want.

(Or it will do the opposite of what you want, in which case you should change your table calculation so that Yes and No switch.)