1 Reply Latest reply: Jul 2, 2015 10:46 PM by Sunny Talwar RSS

    Is there a way to have a filter applied to an entire sheet?

    Mark Bashuk

      I want to create a set of sheets, all tied to the same data source, but that have different data filters that aren't applied to the other sheets.

       

      For example - I want to have a "Today's Orders" sheet and a "Yesterday's Orders" sheet - and have them come from a single data source with a date filter.

       

      Currently, I create two complete separate data sources but I don't really like this method. Any ideas or thoughts if this is something that is in the works?

        • Re: Is there a way to have a filter applied to an entire sheet?
          Sunny Talwar

          From what I understand, you should be able to create flags for 'Today's Orders' and 'Yesterday's Orders' and use them in the set analysis for sheet representing them. So for example Orders for Today can be flagged as 1 and orders from Yesterday can be flagged as 0

           

          If(OrderDate = Date(Today()), 1, If(OrderDate = Date(Today() - 1), 0)) as DateFlag

           

          And then on your Today's sheet use the following set analysis statement

           

          {<DateFlag = {1}, Date = , Month = , Year = , YearMonth = >}

           

          And then on your Yesterday's sheet use the following set analysis statement

           

          {<DateFlag = {0}, Date = , Month = , Year = , YearMonth = >}

           

          HTH

           

          Best,

          Sunny