2 Replies Latest reply: Mar 17, 2016 3:53 AM by Andrea Bazzoni RSS

    Count number of occurrences in a chart

    Andrea Bazzoni

      Hi everybody,

       

      i'm trying to add a field in a chart to count the number of times a value in a specific field is repeated. This is what i have:

      The field i'd like the value to be counted is "PDR" and, as you can see from the image, it's the same for both rows and what i need is a field that, in this case, gives me "2" as a result because the value contained in the "PDR" field is repeated twice.

      I tried with the count distinct expression but it always returns "1" as a result, maybe i did something wrong (Siti.COD_DISTRIBUTORE_GAS it the complete name of the field labeled as "PDR" in the chart):

       

      Count(DISTINCT [Siti.COD_DISTRIBUTORE_GAS])

       

      Can anybody help me?

       

       

      Thanks in advance,

       

      Andrea