1 Reply Latest reply on Aug 31, 2018 2:41 PM by Patrick A Van Der Hyde

    Multiple Filters without a parameter

    Ashok Ramineni

      Hello,

      I have 3 quick filters i.e. Transportation, City & Name.

      I would like to display the 2 calc fields wrt to month without creating any parameters in place of quick filters because relevant values will not working as expected.

      Need to pass all the below  filters and match the results.

       

      Avg= countd(TRXID)/Countd(date)

      LSA & LS are pre calculated fields

      Ex:

       

      By Default

      When Transportation="All", City="All' and Name="All'  

      Display same value in both calc fields for change in Transportation

      When Transportation="Air", City="All' and Name="All'                                                                                             When Transportation="Ground", City="All' and Name="All'

                    

       

       

       

      When Transportation="All", City="Oklahoma City' and Name="All'

       

      When Transportation="Air", City="Oklahoma City' and Name="All'                                                                      When Transportation="Ground", City="Oklahoma City' and Name="All'

            

       

       

      When Transportation="All", City="All' and Name="Justin Ritter'  

       

          When Transportation="Ground", City="All' and Name="Justin Ritter'        

       

          When Transportation="Ground", City="Oklahoma City' and Name="All

       

          When Transportation="Ground", City="Oklahoma City' and Name="Craig Reiter

       

      I hope it is clear. Please let me know for any clarifications.

       

      Thanks!