8 Replies Latest reply: Apr 13, 2012 10:08 AM by Mathias Vanden Auweele RSS

    Calculate distinct values ignoring one dimension

    Mathias Vanden Auweele

      Dear all,

       

      I want to make a chart with the count of the distinct values in my dataset over a certain time period. So I have an expression count( distinct VALUE) and a dimension MONTH.

       

      However, when I define such a chart I get the count of distinct VALUE per MONTH and not over the total period. I only want to see 1 entry of VALUE in my entire chart. How can I realise such a thing?

       

      Thanks!