We use webi for reporting at work. One of the fields we have has "languages spoken" in it, as colon-separated values. So if someone only speaks English their field would show "English". If someone else speaks English, Cantonese and Mandarin, their field would appear as "English;Cantonese;Mandarin".
I need to create a chart that shows how many people speak each language (preferably just the top 5 since we have about 15-20 possible choices). If I just use the field as-is, I don't get every language separately - the "English;Cantonese;Mandarin" person gets counted only once, on their own row, instead of once on the English count, once on the Cantonese count, once on the Mandarin count.
Does anyone have any ideas how to do this? Unfortunately I can't flatten this value during universe creation (I have very limited control over the universes). Someone suggested creating a variable for each language and using the Match function to separate each long string into separate ones. However there are multiple issues with that:
1. We have a lot of languages, so that's annoying and inelegant, but if it's what we have to do then we'll do it.
2. It's not dynamic - if we add another language in the future, we'll have to redo that entire section. Again, doable but inelegant.
3. I can't seem to find a way to create a bar chart that can show multiple variables as separate columns. Essentially it means this just doesn't work. I could use a "form" element, but I'm not sure I can even sort it from highest to lowest, let alone add ranking (because again, these are all different variables).
"Please leave a message at the beep, we will get back to you when your support contract expires."
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 3 guests