With the dates specified as strings like that, choosing the latest date is
going to be tricky, unless there is some structure to your data that you
can take advantage of (like "the latest date is always in the first row of
data" or something similar). If you can't depend on the structure to tell
you the latest date, then you should switch to using a "date" type column,
which contains Date objects that you can sort appropriately.
On Tuesday, June 10, 2014 4:49:53 PM UTC-4, ali wrote:
>
> Whenever the page renders or refreshes, the table should always go back to
> default latest date's data. The users should be able to filter table by
> dates the using the category filter control.
>
> Thanks
>
> On Tuesday, June 10, 2014 9:34:47 PM UTC+1, Andrew Gallant wrote:
>>
>> Do you want the user to be able to change it, or should this be
>> unchangeable?
>>
>> On Tuesday, June 10, 2014 4:29:34 PM UTC-4, Missy wrote:
>>>
>>> I would like to be able to show, only the latest date data (table) when
>>> the web page renders.
>>>
>>> Thanks.
>>>
>>>
>>>
>>> On Tuesday, June 10, 2014 5:58:25 PM UTC+1, Andrew Gallant wrote:
>>>>
>>>> You set up a filter for the date column, are you trying to set the
>>>> default value for the filter, or do you always want to show only the
>>>> latest
>>>> date?
>>>>
>>>> On Tuesday, June 10, 2014 5:50:28 AM UTC-4, ali wrote:
>>>>>
>>>>> Hi,
>>>>>
>>>>> How can I create event, which can render table's only showing
>>>>> yesterday's date data (recent date only - 9June). I have started the
>>>>> function and but little unclear about the coding logic. Any guide would
>>>>> be
>>>>> greatly appreciated. Thanks.
>>>>>
>>>>> function drawVisualization() {
>>>>> // Prepare the data
>>>>> var data = google.visualization.arrayToDataTable([
>>>>> ['Country', 'Region/State', 'City', 'Date'],
>>>>> ['USA', 'California', 'San Francisco', '9 June'],
>>>>> ['USA', 'California', 'Los Angeles', '9 June'],
>>>>> ['USA', 'California', 'Mountain View', '9 June'],
>>>>> ['USA', 'New York', 'New York', '8 June'],
>>>>> ['USA', 'New York', 'Albany', '8 June'],
>>>>> ['France', 'Ile-de-France', 'Paris', '8 June'],
>>>>> ['France', 'Ile-de-France', 'Orly', '6 June'],
>>>>> ['France', 'Provence', 'Marseille', '6 June'],
>>>>> ['France', 'Provence', 'Nice', '6 June']
>>>>> ]);
>>>>>
>>>>> var datePicker = new google.visualization.ControlWrapper({
>>>>> 'controlType': 'CategoryFilter',
>>>>> 'containerId': 'control3',
>>>>> 'options': {
>>>>> 'filterColumnLabel': 'Date',
>>>>> 'ui': {
>>>>> 'labelStacking': 'vertical',
>>>>> 'allowTyping': false,
>>>>> 'allowMultiple': false
>>>>> }
>>>>> }
>>>>> });
>>>>>
>>>>> // Define a table.
>>>>> var table = new google.visualization.ChartWrapper({
>>>>> 'chartType': 'Table',
>>>>> 'containerId': 'chart2',
>>>>> 'options': {
>>>>> 'width': '500px'
>>>>> }
>>>>> });
>>>>>
>>>>> new
>>>>> google.visualization.Dashboard(document.getElementById('dashboard')).bind([countryPicker,
>>>>>
>>>>> regionPicker, datePicker], [table]).draw(data);
>>>>>
>>>>> google.visualization.events.addListener(table, 'ready',
>>>>> function () {
>>>>> var filteredData = table.getDataTable();
>>>>> var group = filteredData.getDistinctValues(4);
>>>>> for (var i = 0; i < group.length; i++) {
>>>>> // little confused here
>>>>> }
>>>>>
>>>>> });
>>>>>
>>>>> }
>>>>>
>>>>
--
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/d/optout.
