I am trying to use the following script to modify my Report chart data but it doesn’t appear to do anything. Any thoughts?
chartData = event.source.parent.getComponent(‘CategoryChart’).data
ColumnCount = [1,2]
filteredData = system.dataset.filterColumns(chartData, ColumnCount)
event.source.parent.getComponent(‘CategoryChart’).data = filteredData
Where is this code? The syntax suggests a Vision component, but your title says a chart in a Report. Please elaborate.
In the script of a Category Chart on a Report. If I am using the wrong syntax. Is there a way to do what I am looking to do? If so, how?
Hi @ryoungk, just to be clear, are you referring to Report charts which are part of the reporting module, or Vision charts
As @pturmel suggested, the script syntax suggests Vision.
Could you post any screenshots or code snippets so we can get a better understanding of what is going on?
Yes in a report chart. Pardon the marks, I am trying to avoid sharing IP.
Thank you just wanted to make sure we’re all on the same page
That’s absolutely fine, I think there’s enough to go on.
Right, I am no expert on this, but here we go. The docs state:
The look and feel of the Timeseries, XY, and Bar charts may be modified through scripting.
This suggests to me that it is not really the place for data manipulation. Is it not possible to only get the required data at the data source level?
If not, you may be able to use the
data argument of the
configureChart function to manipulate the chart. You will likely need to do this via the JFreeChart API. I have never done this, so I wouldn’t be best placed to advise on how to do it
matthew.ayre is correct – this isn’t the spot to modify the data.
If you have a report data source you want to modify, use a script data source. Each data source has access to the data sources defined above it, so your script data source can modify the data from other data sources. The docs have examples of how to do this.