Charts for columns with semi-colons


Author
Message
Bob Smith
Bob Smith
Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)
Group: Forum Members
Posts: 69, Visits: 1

I would like to create a chart based on two column values in a SharePoint list (Title column can be used as a filter):

Title: Entry 1

Produce: Apples; Oranges; Bananas

Quantity: 10; 8; 14

I would like a bar chart that has Apples, Oranges & Bananas on the X Axis and the quantity values on the Y axis. If there is a simple way to do this then one could easily use a "merged" data column as produced by MS InfoPath.


Reply
Bob Smith
Bob Smith
Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)
Group: Forum Members
Posts: 69, Visits: 1
Hey! Sorry for taking so long to get back - I must not have been subscribed.

I am trying to use Nevron Charts to display data that was created by a multi-value checkbox or repeating field in an MS InfoPath form. For example, a form might have on it a field that states "Check all that apply:". InfoPath can turn that field into a semi-colon delimited entry in a SharePoint site column. For example:

Ice Cream Flavors that you like (Check all that apply):
Vanilla
Chocolate
Strawberry
Rocky Road

The resultant answer might look like this: Vanilla; Chocolate; Strawberry

That would be the literal value of the entry in a site column in the form library.

The answer in this situation is *most likely* the "Split" text function, although I'm not sure how to apply it in context. I was hopeful that there might be an example somewhere or more specific documentation regarding the use of "Split".
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search