charts

 
1
0
-1

hello, I would like to ask, how can I to to create (if it's possible) chart which will display information about status of invoices vs date (like 1.2.21 were 10 posted invoises and 20 created invoices). currently i have succeed created only charts type value of invoice vs date

  1. Ian

    Can you provide a sample app? 

  2. Nat Marsh

    APP_invoicing-2-20210218134510.jwa

CommentAdd your comment...

2 answers

  1.  
    1
    0
    -1

    hello, I have tried the following  SQL:

    select count(*), status, issueDate
    from app_fd_new_invoice_form
    where status = 'posted'
    group by status, issueDate
    order by issueDate desc

    But there are errors in system logs I have field status in my form 



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

      In your SQL, try using the "SELECT .... COUNT(*) ...." function instead of "COUNT(dateCreated)", since you already done the "GROUP BY monthYear" grouping. See https://www.mysqltutorial.org/mysql-count/#:~:text=The%20COUNT(*)%20function%20returns,non%2DNULL%20and%20NULL%20rows.

        CommentAdd your comment...