2 Replies Latest reply on Nov 14, 2017 12:47 PM by Chris Reech

Exclude charts in which most recent value is 0 or null

Chris Reech Nov 14, 2017 10:54 AM

Hi,

Newbie here. Working on a trending chart and need to filter out rows (as in entire chart) where the most recent value is null or 0.

Sorry, I'm not able to share due to its proprietary nature. However, a screenshot is attached.

Thanks for the help!

Chris

1. Re: Exclude charts in which most recent value is 0 or null

Deepak Rai Nov 14, 2017 11:08 AM (in response to Chris Reech)

What I can Suggest from the screenshot is that you need to drag SUM(YOUR MEASURE) to Filter and Go to Special and use Non-null Values. If this does not works for you attach a mock up sheet.
Like Show 0 Likes(0)

Actions
2. Re: Exclude charts in which most recent value is 0 or null

Chris Reech Nov 14, 2017 12:47 PM (in response to Deepak Rai)

Thank you! That took care of it.
Like Show 0 Likes(0)

Actions

Tableau Community