3 Replies Latest reply: Nov 9, 2017 4:08 AM by Andrea Gigliotti RSS

    Using Filters

    Mahesh Gandem

      Hi,

       

      Need a help, i have few city names, while doing count of these cities, I do not want few city names to be appearing while fetching the data, pls help me with the same.

       

      sample city names given below

       

      from the below, need to apply one more filter of city names

      =COUNT({<cust_id = {"=count(cust_id)>2"},location={'HYD_Retail'}>} DISTINCT complaint_no)

       

      1.Hyd

      2.Chennai

      3.Mumbai

      4.Delhi

      4.Bangalore

       

      out of the above, i only need Hyd & Chennai and rest of the city names should not get populated