8 Replies Latest reply on Jun 14, 2018 8:40 AM by Paul Whitaker

    Filtering multiple columns

    Paul Whitaker

      Hi,

      I've simplified my earlier question and data so I can attach it here.

      What i'm trying to achieve is to detect the change on site 7 where it had been 'on' for 2 months but is now off.

      This would be easy in excel, I'd just filter the 1st months column for 'on' and the most recent month for 'off' but I'm at a loss as to how to do it in Tableau.

      My real dataset is much larger (60k+ sites) with multiple sub sites.

      I'm guessing this may need to use LOD calculations??

      Any help would be appreciated

      PW