Hi!
I'm using Phprunner 5.2 and need to see a line chart with 3 lines.
I have a table with several registers in one day. When I edit the query of this table in order to see an chart I do that:
SELECT
DATE(DatEve),
Motorista,
SUM(Vel_Max_Plano),
SUM(Vel_Max_Chuva),
SUM(Vel_Max_Bangela)
FROM TLMardan
GROUP BY DATE(DatEve);
That means I want to see how many times the drivers (Motorista) exceeds the max speed in a day in 3 different conditions. The DatEve is a timestamp field.
The query is OK when I go to the Results tab in Query windows, but the chart refuses to show the sum of the fields, showing only zeros from the first until the last day of the roll of registers.
Can anyone knows what's going on?
Tks!