5 Replies Latest reply: Aug 26, 2014 12:20 PM by Raj Kanapathy RSS

    Filtering out data in Straight Table

      I have a straight table with a load of data in it. How would I add a filter so that I only see rows where a value in one of the columns is > 100, for example?

        • Re: Filtering out data in Straight Table
          Jonathan Dienst

          Hi

           

          You have a number of options open to you:

           

          • If the amount is fixed, then you could add a flag in your load script and then filter on the flag.
          • If the amount can be one of only a few values, you could create intervals for these values and then intervalmatch the intervals. Then filter on the intervals (depending on user selections).
          • You may be able to apply a filter to one or more of the dimensions (by using a calculated dimension).
          • You can filter the data columns (you must do this to all the columns). Lets say the value of interest is in Column 1:

           

                         =If(expression1 > 100, expression1)

                         =If(Column(1) > 100, expression2)

                         =If(Column(1) > 100, expression3)

                         =If(Column(1) > 100, expression4)

                         ....

               (oh, and ensure that suppress null values is ON)

           

          There may be others. Without more information on your requirements, its hard to be specific.

           

          Hope that helps

          Jonathan