i want to make a list that display total by department

 
1
0
-1

hi experts,


i want to make a datalist that display total application fro every department. how?

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi Dayana,
      If the total application an existing column in the same form with the department column?

      if that's the case .
      You can just drag and drop the 
      Application Column and the Department Column in the List builder. 

      However,
      If both of the columns are from different forms(Which from different tables)
      you can make use of the Advanced Form Data List Data Store


      You can join both of the tables .
      You can also make use of the Aggregate Query if you want to display sum for the specific column.

      Hope it helps.

      1. dayana afiqah

        yes, but i want to display the total by department

      2. John Smith

        Okay.then maybe you can have the department to be as a filter.

        Then You can filter out according to the department that you want only.

        You can only see the application total based on the department that you have filtered out only?.

      3. dayana afiqah

        ginger, can you help me, i try to do the datalist using sql but it appear error : ERROR 19 Jul 2024 15:05:13 /jsp/dbuilder/dataListView.jsp - Error rendering datalist


      4. John Smith

        Dayana,
        Change the data store and you can Try to use the aggregate query to have the application column to be count up using the existing feature?
        try to have it a go. 

        By the way, the process_id column, is it in the same form?
        Or is it from different one?
         

      CommentAdd your comment...