G
GillesABelanger
Good evening,
I am trying to group the results on 10 yes/no fields by showing the quantity
of no's compared to the total number of boxes checked for each of those 10
yes/no fields! The first field is easy to chart, however adding the second
and the other fields is kind of filetering the results and I see only the
common fields that all have yes. I cannot chart the variations of results
for each yes/no field. ALl the bars have the same hieght per day!
I have been trying all day to break the barrier. There seems to be no way
to make it happen.
I am thinking of making two fields one for "yes" and one for "no" to make
the charting easy; however, I think there should be a way to split those
data from one single column. Is this possible? Am I dreaming?
Thanks
Gilles
Somehow, the pivot chart is filtering
I am trying to group the results on 10 yes/no fields by showing the quantity
of no's compared to the total number of boxes checked for each of those 10
yes/no fields! The first field is easy to chart, however adding the second
and the other fields is kind of filetering the results and I see only the
common fields that all have yes. I cannot chart the variations of results
for each yes/no field. ALl the bars have the same hieght per day!
I have been trying all day to break the barrier. There seems to be no way
to make it happen.
I am thinking of making two fields one for "yes" and one for "no" to make
the charting easy; however, I think there should be a way to split those
data from one single column. Is this possible? Am I dreaming?
Thanks
Gilles
Somehow, the pivot chart is filtering