5 Replies Latest reply: Sep 11, 2017 9:27 AM by Antonio Mancini RSS

    Inclusive Count Function

    Meghann MacDonald

      Hi all,

      I am trying to format a gauge to count all URL's that have a Location = SFDC AND a Location = Qlik.com. I cannot get my function to work as I don't know the proper formatting. So far, I have

       

      =Count(DISTINCT {< [LOCATION] = { 'SFDC','Qlik.com' } , [Language] = { 'English' }, Format -= {'A4'} >} [URL] ) ) )

       

      that I know works, but includes all assets categorized as SFDC or Qlik.com, not only those that are both.

      Thanks!