I created a chart in a layout and sorted in using Semester and it worked correctly.
I wanted another chart by the side and so I created a new table instance in the relationship and I modified the filters in the script "Apply Year Filter" under the Admin folder in the script workspace. I also have a dropdown to select the year.
The left chart splits the TotalSummary of the Approved hours in the table by Semester.
In the right chart, I want to split the chart by Centers which is not working properly.
I have attached the file, the layout is "Graph 1612" under the Admin folder. Any help is appreciated.
Username & password: csd