Skip to main content

In this workbook, in the last column I have a LOOKUP to see the date of the previous step, but when I add a filter of Min WC# (removing the nulls), it no longer shows those dates. Is there a way to maintain the dates that it shows prior to the filter?

3 risposte
  1. 16 feb 2022, 05:23

    Hi @Spencer Abbott​ 

    I'm not entirely clear what you're trying to filter out, but ... wanting to filter out data without affecting a table calc is usually something you can achieve. If you filter on a table calc itself then that filter is done after the other table calcs are calculated, hence you get what you're after (I think of table calcs as being executed on what is showing in the view, and so a normal filter removes the data for the table calc before it's had a chance to be executed).

    You'll often see a filter on a calc like LOOKUP(MIN([date]),0) instead of [date] to trick Tableau into filtering on a table calc that just looks up the date for the row in the view.

    In your case I tried wrapping Min WC# in a LOOKUP(MIN(...),0), dragging it on to filters, excluding NULL and then editing it's table calc to set the compute by to match your existing table calc. Not sure if it does what you want but workbook re-attached just in case. And the principal should be good to apply even if I've not quite got the filtering right!

    Ta, Steve.