Webi/Business Objects help!

"Please leave a message at the beep, we will get back to you when your support contract expires."

Moderators: phlip, Moderators General, Prelates

User avatar
Zohar
COMMANDER PORN
Posts: 8169
Joined: Fri Apr 27, 2007 8:45 pm UTC
Location: Denver

Webi/Business Objects help!

Postby Zohar » Fri Sep 04, 2015 4:04 pm UTC

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).

Any pointers?
Mighty Jalapeno: "See, Zohar agrees, and he's nice to people."
SecondTalon: "Still better looking than Jesus."

Not how I say my name

Return to “The Help Desk”

Who is online

Users browsing this forum: No registered users and 3 guests