handling/cleaning data

[Anonymous]

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

[matteo901p]

In your script, you can add a field like this
UPPER(activities) as UPPER_DESCFIELD,

In presentation, you add a graph with

DIMENSION: UPPER_DESCFIELD

MEASURE : your expression

[OmarBenSalem]

you can even do it directly in the presentation; I mean the Upper(activities) as a dimension in your bar chart

[Anonymous · Accepted solution]

also you can use capitalize() function in script to bring it to same format

[Anonymous]

Awesome. Many thanks for this. Sorry for taking your time. I feel I should have looked this up!

[Anonymous]

Many thanks. Works very well now.