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 way to suppress its display?
Suzanne On Wednesday, January 4, 2017 at 6:09:01 AM UTC-8, Daniel LaLiberte wrote: > > 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 doing. > > On Tue, Jan 3, 2017 at 7:58 PM, Suzanne Paley <suzann...@gmail.com > <javascript:>> wrote: > >> 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 provide the users with multiple sort options, including >> some based on calculated values, such as the maximum or minimum over all >> user-selected series, or the difference between the maximum and minimum of >> user-selected series. I can create a calculated column in my view that >> generates the values the user wants to sort on (though I wouldn't want to >> display such a column, so there doesn't seem to be an appropriate role for >> it), but I can't figure out how to sort on it -- getSortedRows seems to >> take only column indices from the base table, not calculated columns. Is >> there a way to do what I want? If not, can I put in a feature request for >> calculated sort columns? >> >> Thanks, >> Suzanne >> >> -- >> > -- > Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> > dlali...@google.com <javascript:> 5CC, Cambridge MA > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/a428436a-2767-4787-b911-2d27d754e80b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
