Re: [visualization-api] calculated sort column?

2017-01-04 Thread Suzanne Paley
Thanks for your help. Creating a new view that contains only my calculated sort column, and then sorting my original view by setting its rows to be getSortedRows of the new view column works well for me, without being too disruptive to my existing code. E.g. https://jsfiddle.net/fbkwmjjL/1/

Re: [visualization-api] calculated sort column?

2017-01-04 Thread 'Daniel LaLiberte' via Google Visualization API
You could create yet another view that only lists the columns you do want to use in the chart. If you are using a ChartWrapper, you can do this with a 'view' property. We don't have a role to 'ignore' a column, though I can see that might be useful. On Wed, Jan 4, 2017 at 12:10 PM, Suzanne

Re: [visualization-api] calculated sort column?

2017-01-04 Thread Suzanne Paley
Hi Daniel, If I don't want the calculated sort column to appear in my graph, what can I do? If it's included in my view, by default it will be shown as an additional series. The only other numeric role that seems to be available to me is interval, which is not what I want either. Is there a

Re: [visualization-api] calculated sort column?

2017-01-04 Thread 'Daniel LaLiberte' via Google Visualization API
Hi Suzanne, I believe the getSortedRows() method should work with calculated columns as well. Here is an example showing that it is working as I would expect: https://jsfiddle.net/dlaliberte/fbkwmjjL/ Perhaps you have found a bug, but if so, we would need to see the details of what you are

[visualization-api] calculated sort column?

2017-01-03 Thread Suzanne Paley
I have an underlying DataTable with discrete x-axis categories and multiple series. I'm using DataViews on top of that to generate column charts, so that users can select which series to display (including calculated series that may aggregate multiple source series in various ways). I want to