This topic is locked

Customize time for chart

1/16/2012 10:43:47 AM
PHPRunner General questions
S
sickacid author

Hi,

is possible customize time for a chart?

if I select form table the coloum with hours, i can't view it in the data series select. I've to use SUM of filed to view it.
SELECT

OreLavorate,

SUM(tabelladischetti.OreLavorate)/10000 AS ore
With this query i obtain tow results for the same field:
02:02:00 2:02
is the only way I've found to have 'ore' field in the series select. But is correct? or there is another way to display time?

I've look there: http://www.anychart.com/products/anychart/docs/users-guide/label-text-formatting.html?fromtree#keywords but I haven't find nothing.

C
cgphp 1/16/2012

Your question is not very clear. If you want to get only the 'ore' result, select only the SUM of 'OreLavorate':

SELECT

SUM(OreLavorate)/10000 AS ore