- This topic is empty.
08/22/2011 at 12:02 pm #4988
Would you mind to mention the QWP and SP version and also to attach the list and the qChartView configuration to this tread? It'd help me to better understand the issue.
10/20/2011 at 7:46 am #6764
SP – 2007
QWP – 5.3
Chart output as configured below:
What I would like to see based on the data
10/20/2011 at 7:55 am #6765
I see, you want to count the multi selection values in the list based on single selection value.
I don't think that this is possible. The XAxis value is treat as a string and has no capacity of counting inside strings.
I'm thinking of a helper list here. A list that would hold the individual selection adn the counting. This can be accomplished with some coding.
You desired chart screenshot comes from a different list not from the list you want to use, right?
10/20/2011 at 8:01 am #6766
, thanks. I was hoping for a simple answer that it could be handled in the chart but I expected this to be the real solution. You are correct, I dummied up the data to give a visual of the desired result.
10/20/2011 at 8:10 am #3932
I have a choice field where people can select one or more values. When I add this to a chart, it looks at the value as a coma delimited list and does not count each value individually.
value 1 –> A,B,C
value 2 –> C
value 3 –> B,D
What the chart is plotting is:
What I would like plotted is:
Can this be done?
10/20/2011 at 8:10 am #6767
The chart has no idea that the xAxis is a multi selection field, it sees it as a string.
Another workaround that I was thinking of is changing the multi selector field with several lookup fields. I don't know if this solution would fit your business requirements but it's worth to mention it.
You must be logged in to reply to this topic.