katragadda123
Programmer
Hi,
I am trying to create a grouped stacked bar chart.
For 'on change of ' i have -> 1) update_month
2) update_source ( i have 2 values for this field -> website and ivr)
And for 'show value' field i am trying to use 1) sum of valid_count
2) sum of invalid_count
-> I need two stacked bars for each month, each stacked bar belongs to either website or ivr and is made of valid and invalid counts for that particular update source.
when i tried to use the fields as i mentioned above, i got an error saying
'The data you have selected doesnt fit the chart type' and explanation is as follows 'This chart type requires 2 on change of fields and i show value field OR 1 on change of field and many show value fields'.
I have selected a stacked bar chart.
Does any one know how to do this?
i am trying to create a chart similar to the one in the following link
Thanks,
Preethi
I am trying to create a grouped stacked bar chart.
For 'on change of ' i have -> 1) update_month
2) update_source ( i have 2 values for this field -> website and ivr)
And for 'show value' field i am trying to use 1) sum of valid_count
2) sum of invalid_count
-> I need two stacked bars for each month, each stacked bar belongs to either website or ivr and is made of valid and invalid counts for that particular update source.
when i tried to use the fields as i mentioned above, i got an error saying
'The data you have selected doesnt fit the chart type' and explanation is as follows 'This chart type requires 2 on change of fields and i show value field OR 1 on change of field and many show value fields'.
I have selected a stacked bar chart.
Does any one know how to do this?
i am trying to create a chart similar to the one in the following link
Thanks,
Preethi