Hi
Is it possible to display multiple options as single options in a chart. I have a SharePoint list with six user profiles where more than one user profile can be selected. This means that my chart is impossible to decipher because each of the different combinations shows up as a separate new entry. I'd like to see the number of records that just has each of the user profiles assigned. For example, how many records have the Developer user profile assigned, not listing records that have the Admin and the Developer user profile assigned as a separate entry from the one with just the Developer user profile assigned (there seems to be over 10 combinations of these).
Is there a setting that I'm missing?
Thanks
Kristine
Your course of action:
- Go to Data Source -> Advanced, replace existing handlers.requestSuccess function with the following:
handlers.requestSuccess = function(data, logger) {
var newDataItems = [];
for (var i = 0; i< data.items.length; i++) {
var currentItem = data.items[i];
//MultiChoice is the internal name of the roles column (developer, etc) - replace as appropriate
for (var p = 0; p < currentItem.MultiChoice.length; p++) {
var newItem = $.extend(true, {}, currentItem);
newItem.SingleRole = currentItem.MultiChoice[p];
newDataItems.push(newItem);
}
}
data.items = newDataItems;
return true;
}
- Click “Process”
- In Data Source -> Aggregation select “SingleRole” as the Group By column. Click Process.
- In Dashboard -> Chart select:
Display each group as separate series - yes
Category - SingleRole
Value - whatever you had before
Aggregate over category - yes
Function - sum
That should do it, let us know if you run into problems
]Hi again
I know it's probably because I did this wrong, but I didn't have any luck:
[attachment=0]plumsail_multiple options1.png[/attachment
Like you have done in the previous forum thread, you need to use the internal name of the field which you have correctly identified last time in the CamlQuery section. (Where it says ).
Also, I see you’re using ID as the value field, so I suppose you’ll want the count function, instead of sum.
Hi again
I'm really sorry to be so slow on the uptake, but I'm not getting the right result. I still see a single block of green. The only internal reference that I could see was Word_x0020_document_x003a_User_x, which I tried replacing in the code in the Advanced section. I also changed the Sum to Count in the Function field, none of it works.
Here's the Caml query:
