The Query language doesn't support selecting the last x rows without adjusting the cell range. You can query the whole data set and use a DataView to restrict to the last x rows, if that works for you.
On Friday, November 22, 2013 2:37:09 PM UTC-5, Michał Kowalski wrote: > > Unfortunately I have date and time in one column and I really don't want > to change it. I just want to find a way to choose only X last rows and make > a chart from them. > > W dniu piątek, 22 listopada 2013 14:49:50 UTC+2 użytkownik Michał Kowalski > napisał: >> >> Hi, >> >> I've created line charts based on spreadsheet document. On server side a >> python script add a new row every 10 minutes. After some time the chart >> starts to be quite 'unreadable'. >> >> My question - is there a way to show entries from last 24h? Or just show >> some previously entered numer of entries? >> >> Thanks for your help >> Michał K. >> > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
