3 Replies Latest reply: Sep 21, 2012 11:11 AM by ioannis giakoumakis RSS

    using a field name as a bookmark name

    ioannis giakoumakis

      Hi all.

      I have the following expression which works as expected :

       

      Count(DISTINCT {BM01} personid) where BM01 is a bookmark id.

       

      What I need to do is replace BM01 with a field i.e. Bookmarks in which I have loaded all bookmarks IDs. So my expression should look like that :

       

      Count(DISTINCT {[Bookmarks]} personid)

       

      so that if I add this expression in a chart with Bookmarks field as a dimension, I would get one value per bookmark.

       

      The above does not work. Any suggestions?

      Thank you

      Ioannis.