5 Replies Latest reply: Oct 27, 2017 7:19 PM by Chris Lowther RSS

    handling/cleaning data

    Chris Lowther

      I have a table of activities (e.g. boxing, soccer, guitar) and want to produce a simple bar chart with a count of the occurance of each activity. The table is collected from an online form filled in by participants, resulting in, for example 'boxing' being entered as Boxing, or boxing, or BOXING. Each variation in case and spelling results in a separate count, In my example I'd have three different bars in my chart.

       

      Is there any way of dealing with this in the Expression Editor? Or any other recommendations please.

       

      Many thanks, Chris