I have a table as such:

Assigned to | status | COUNT status
________________________________
Joe | Active | 3
Joe | Inactive | 1
Bill | Active | 6

"Assigned to" is a term reference.
aggregation is on
D7

I'm attempting to create a column chart that will group "assigned to" together and display the count. I created a normal table view first. Its set to display all records. The view displays the above listed information. Then I cloned the table and changed it to a column chart. Without a filter present, it will display the three columns accurately and as expected. I changed the name of this chart to "Active". I am pulling the labels from "Assigned to." I then created a filter to select only records for "status" equal to "Active." The chart displayed accurately. It shows two columns. One column labeled "Joe" at "3" height (on hover). One column labeled "Bill" at "6" height (on hover). If I change the filter to Inactive I get one column labeled "Joe" at "1" height and value on hover. I then changed the filter back to active. Everything displays as expected.

I then create a "chart addon" and link it back to "Active". I set the filter for "Assigned to" to "Inactive". Change the color for the chart addon.

Switch back to the main chart I now have three columns. The two "active" columns display properly with Joe/3 , Bill/6. The inactive column has a value of "1" but the label now reads "Bill". The Inactive column is also grouped with "Bill" (displayed next to "Bill's" active column.)

The same thing occurs when I create the chart without cloning the table. The same error occurs when I create the column chart without creating the table first. On creating pie charts from the same nodes the data displays correctly.

Does anybody have an idea what would cause this unexpected behavior?

Comments

rudyard55’s picture

rudyard55 CreditAttribution: rudyard55 commented

It definitely has something to do with the application of the filters in the view.

When I create both the Parent chart and the Addon chart and apply NO filters I end up with what you'd expect. Dual columns on the parent chart with the correct values and labels displayed. As soon as I apply the filters for "Status" (active/inactive) things get odd.

I also changed the view to count NID as opposed to counting the status field and it resulted in the same above described odd grouping and mislabeling.

alibama’s picture

alibama CreditAttribution: alibama commented

having the same issue - oddly enough the chart add-on works correctly (the right labels are in there) but when it's added to the main chart it breaks and only shows the labels from the main view

Pierre.Vriens’s picture

Pierre.Vriens CreditAttribution: Pierre.Vriens commented
Status: Active » Postponed (maintainer needs more info)

Sorry it has taken so long to get back to this issue (I do so now anyway ...). Does this issue still exist today? If not: any idea what the clue (solution) for it was?

If it still exists, can you verify if the (newly created) Create charts using Views documentation, and especially its child page Steps to create charts using the views UI might help to find out what is causing the problem?

Exploratus’s picture

Exploratus CreditAttribution: Exploratus commented

I have this problem as well.