When I chart this using date time, grouping by day, a Jan 27th bar appears twice and Jan 28th not at all. By looking at the size of the bar chart I can tell it is thinking some of the 27th Jan are the same as 28th Jan and labelling this 27th Jan. There is then another bar of the rest of 27th Jan.

When I set the column type as Date (so all the times are the same) this problem does not occur.

On 8/28/2012 6:23 AM, James Whitehead wrote:
> Hi,
>
> I've created an oda to query and read responses from a webservice. I can
> get back dates in the results. I parse these results via:
>
> return new java.sql.Timestamp(time.parse(sourceData.get(m_currentRowId -
> 1).get(index - 1)).getTime())
>
> (m_currentRowId and index point to where in my sourcedata the date is.)
>
> This produces a list of dates such as:
>
> 29 Jan 2012 20:40 27 Jan 2012 23:01 27 Jan 2012 21:53 29 Jan 2012 14:54
> 28 Jan 2012 09:05 27 Jan 2012 21:47 27 Jan 2012 19:45 30 Jan 2012 17:27
> 29 Jan 2012 12:09 28 Jan 2012 14:11
>
> When I chart this using date time, grouping by day, a Jan 27th bar
> appears twice and Jan 28th not at all. By looking at the size of the bar
> chart I can tell it is thinking some of the 27th Jan are the same as
> 28th Jan and labelling this 27th Jan. There is then another bar of the
> rest of 27th Jan.
>
> When I set the column type as Date (so all the times are the same) this
> problem does not occur.
>
> Any ideas to why this is happening?
>
> Thanks,
>
> James

I am trying to recreate the issue, but it does not look like the dates
are the same in the xls sheet. BTW do you have aggregration on the
x-axis disabled? Is the x-axis type set to date time? What are you
using for the y-axis values?

Jason

On 8/29/2012 5:32 AM, James Whitehead wrote:
> Hi Jason,
>
> The print screen was taken of charts using 2 datasources based on identical data and set up, with the only difference being I changed the output column type to from date time to date.
>
> I have also uploaded an excel file of the results shown in Preview results for each (thery are in random order but are the same data points).
>
> Thanks for your help,
>
> James
>

I dumped your dates to a csv and I get the exact same charts when I
change the x and y values to be date or datetime. Are you setting the
data types in the oda correctly?

Jason

On 8/29/2012 11:42 AM, James Whitehead wrote:
> The data may be shuffled up but the dates are the same (if you get excel
> to sort them into order using data->sort then you should see they match
> up, with just the time being different.
>
> The x-axis is set to group type: date time, unit: days, interval: 1,
> aggregate expression: count
> y is set to date again but aggregated by count.
>
> Thanks for your help, I have no idea what is going on.