Chart based on SQL statement don't show results (or any error)

 
1
0
-1

I am using this Statement for creating a line graph, but graph has no value:

SET @runningTotal = 0;
SELECT
Date,
@runningTotal := @runningTotal + totals.Outcome AS runningTotal
FROM
(Select CONCAT(MONTH(c_CDate),' ',YEAR(c_CDate))as Date,
sum(c_OutCome) as 'Outcome'
from app_fd_trades1
where c_CDate>0
GROUP BY YEAR(c_CDate), MONTH(c_CDate)) Totals


Here is the results of the query in default database:

 

Any idea on how to fix this?

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Issue resolved

      the log said that it was an issue with the SQL code.

      I was able to rewrite my SQL code, in a way that Joget was able to handle:

      SELECT
      Period,
      @runningTotal := @runningTotal + totals.Outcome AS runningTotal
      FROM
      (Select CONCAT(MONTH(c_CDate),' ',YEAR(c_CDate))as Period,
      sum(c_OutComePro) as 'Outcome',
      (SELECT @runningTotal:=0)
      from app_fd_trades
      where c_CDate>0
      GROUP BY YEAR(c_CDate), MONTH(c_CDate)) Totals


      and the chart looks like this (smile)

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Any server log error?

          CommentAdd your comment...