I'm using a chart to display some loading time metrics for our system. The data stored in the database is of type TIME.
When I bind the value to an UltraChart, nothing shows up for values on my column chart if I just pull the data out as Time, so I'm converting the value milliseconds as an INT, but the axis labels just show a value like "19000" which isn't very neat.
Is there a way to use a TIME value as an axis in an UltraChart? If not, is there a way to format the axis labels that can convert a raw count of milliseconds to something more presentable, like Value/1000 + ":" + Value%1000 ?
Hello Tyler,
Thank you for contacting Infragistics.
When you say the data values are stored in the database as type TIME does that mean they could be considered similar to the .NET TimeSpan type?
Yes, the value in .NET is TimeSpan.
Thank you for your response.
There is currently no way to get the chart to display TimeSpan values. I would recommend submitting that as a new product idea at http://ideas.infragistics.com.
However, if you have converted the TimeSpan values to integers, you can change the way the labels are displayed on the Y axis and in the tooltips. I have attached a sample project that uses the IRenderLabel interface to do so.
Please let me know if you have any other questions about this.