3 Replies Latest reply: Jul 25, 2016 10:16 AM by Zbyněk Šedý RSS

    invalid Dimension? - if count distict is more then 3

    Zbyněk Šedý

      Hi, I have datasource with messages from people to clients, people (candidate) belong to client.

      Every candidate has date/time of his reply.

      I wish to see if client has enough of candidates. I can save this dimension, but it does not work - ERROR message Invalid dimension

       

      IF((Count (distinct EMAIL)) > 3, '4 and more', if((Count (distinct EMAIL)) < 4,'3 and less'))

       

       

      If I create new datasource with calculated Count (distinct EMAIL) it works


      IF(LIFETIME_emails > 3, '4 and more', if(LIFETIME_emails < 4,'3 and less'))


      but with this i cannot work with date dimension or atributes of messages...


      Please help