Value Error in Column Graph

[Lachlan]

I have a dataset of products I'm trying to graph from a web service. When using the date field (which is a unix timestamp) as the category and the count of IDs as the values it's providing the incorrect results, even when I set the base unit to days/months/years etc. When I use another field other than date, the count returns what it should (as displayed in the difference between the two graphs in the screenshot). I've experimented with changing the groupings via the ToString() method on the date however it is producing inconsistent results. Any advice on what might be causing this?

[Todor]

Hi Lachlan,

I have attached a sample report demonstrating that when the CategoryGroup Grouping is on '= Fields.date.Year', i.e. the 'Year' property of the date field, the proper values are displayed in the Graph. You may use the sample and try to adjust your Graph.

You may also send us a runnable report definition with sample data that demonstrates the issue for investigation.

Regards,
Todor
Progress Telerik

[Lachlan]

Thanks. That worked.