Re: Dashboard: Hide rows in table

[Sergey Grabkovsky]

Hi, I'm sorry we missed this question before. I don't understand why you want to only show the first n rows. It seems to me that it would cut off your data. The chart can handle a good amount of data, so I don't really see a reason to explicitly limit the amount of data going into it. I believe your issue is coming from the fact that first the ControlWrapper does a filter, and it ends up with less than 7 rows (seems to be 6 rows from the error you've reported), which makes row 6 an invalid row index.

- Sergey

On Fri, May 10, 2013 at 9:43 AM, Chris <cmac...@googlemail.com> wrote:

I am trying to create a dashboard with the Google Charts API.

The dashboard includes a ControlWrapper with the type ChartRangeFilter and two ChartWrapper (LineChart and Table). This setup is working fine, but I want to add one addition.

The LineChart shall show the whole dataset, the Table only a part of it. For example I have 10 rows and in the Table only the first 8 should be shown.

This is my current ControlWrapper:

control = new google.visualization.ControlWrapper({
 'controlType': 'ChartRangeFilter',
 'containerId': 'control',
 'options': {
   'filterColumnIndex': 0,
   'ui': {
     'chartType': 'LineChart',
     'chartOptions': {
       'chartArea': {'width': '95%'},
       'hAxis': {'baselineColor': 'none'}
     },
     'chartView': {
       'columns': [0,1]
     },
     'minRangeSize': 86400000
   }
 }
});

And this the Table:

chart = new google.visualization.ChartWrapper({
 'chartType': 'Table',
 'containerId': 'table',
 'options': {
        width: 470, 
        height: 340, 
        sortColumn: 0,
        sortAscending: false
 },
 'view': {
   'columns': [0, 1]
   //,'rows': [0,1,2,3,4,5,6]
 }
});

When I uncomment the row "//,'rows': [0,1,2,3,4,5,6]" in the table definition I get an error when I move the slider of the ControlWrapper:

Invalid row index 6. Should be in the range [0-5]

Is there a way to get this working?

The reason is that (in this example) in the last two rows are only data in column 3 which is only shown in the LineChart but not in the table.

Thanks in advance!

PS: That's a cross-post from stackoverflow (http://stackoverflow.com/questions/16470755/google-charts-api-dashboard-hide-rows-in-table) and I've posted it also here, since a friend pointed me to this group. I hope that's ok!

--
You received this message because you are subscribed to the Google Groups "Google Chart API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-chart-a...@googlegroups.com.
To post to this group, send email to google-c...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-chart-api?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Ryder Brooks]

Hey Chris, 

 Did you ever figure out how to accomplish this? I'm having the same problem.