As an aside, there is a downside to converting your dates to strings if your dates aren't all evenly spaced: when using strings for the axis values, all data points will be evenly spaced, so if you have the dates '01/01', '01/07', and '01/30', they will all be evenly spaced even though the first two are 6 days apart and the second two are 23 days apart.
On Monday, August 27, 2012 6:30:48 PM UTC-4, asgallant wrote: > > Oh, yeah, you can do that. Use a > DateFormatter<https://developers.google.com/chart/interactive/docs/reference#dateformatter>on > the date column before converting to a string: > > var dateFormatter = new google.visualization.DateFormat({pattern: 'MM/dd'} > ); > dateFormatter.format(dataTable, dateColumnIndex); > > Then, when you call the #getFormattedValue method of the dataTable, it > will return the date formatted in this way. > > On Monday, August 27, 2012 5:56:53 PM UTC-4, rubyminer wrote: >> >> That's not what I'm hoping to do. I want to format the dates that are >> displayed on the horizontal axis of the actual column chart. What you >> suggested changes the date format on the control, not the chart (and that >> only works because in the control columns we don't convert the first one >> from date to string). As mentioned, if I could pass in the format I want >> ('MM/dd') to the getFormattedValue() call, that would be sufficient, but I >> don't think you can do that. I'm just hoping that there is an equivalent >> way to choose the formatting before all the dates get turned into strings. >> >> On Monday, August 27, 2012 12:00:13 PM UTC-7, asgallant wrote: >>> >>> Set the ui.chartOptions.hAxis.format option of the range filter to >>> "MM/dd" >>> >>> On Monday, August 27, 2012 2:34:06 PM UTC-4, rubyminer wrote: >>>> >>>> Hi, >>>> >>>> Previously, I was using a regular ColumnChart (not embedded in a >>>> dashboard) with dates as the domain and I was able to use the hAxis.format >>>> attribute to change the format for displaying dates. I have since upgraded >>>> to a dashboard because I want to use a ChartRangeFilter control like the >>>> one in the example ( >>>> https://code.google.com/apis/ajax/playground/?type=visualization#chartrangefilter_control). >>>> However, as in the example, I'm converting the first column from 'date' >>>> to 'string' (if I keep it as a date column, the horizontal axis boundaries >>>> chop off the first and last columns on the first and last dates), so >>>> changing the hAxis.format attribute no longer has any effect. Rather than >>>> showing up like "03/15", the dates show up like "Mar 15, 2012" which is >>>> not >>>> ideal. I'm not familiar with the getFormattedValue() function that gets >>>> called in this code: >>>> { >>>> 'calc': function(dataTable, rowIndex) { >>>> return dataTable.getFormattedValue(rowIndex, 0); >>>> }, >>>> 'type': 'string' >>>> } >>>> but is there a way I can pass in the format string in that call, or do >>>> something else to get the dates on the horizontal axis to be formatted as >>>> MM/dd? >>>> >>>> Thanks in advance for any help you can provide. >>>> >>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/6BercUUmK_YJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
