Display row count at end of list (as a last row) in data view 2

0
Hello to all,   In the data view we are displaying the attendance list for the employee. If the employee is present then 'P' else empty. Each day in the month as columns such as 1 2 3 4 .... 31.   Now we need to count the present on each days and to be displayed under 1 2 3 4 ... 31.   How to achieve this ?    Regards Sudhir  
asked
4 answers
0

Hi Sudhir,

Based on the Excel snapshot you shared, I assume you are creating attributes for each day (e.g., Day1, Day2, etc.). You can follow this approach:

  1. Use an Attendence entity with attributes like Day1, Day2,... etc. containing 'P' or empty.

  2. Create a non-persistent AttendenceSummary entity with Day1Total, Day2Total,.. etc.

  3. In a microflow, loop through all Attendence records and count 'P' for each day, updating the AttendenceSummary.

  4. On the page, show the attendance grid, and below it, use a DataView (with microflow source) to display the totals for each day.

Let me know if you have any doubt. 

Thanks

answered
0

Hello Sudir,

Looks you want to display attendance of an employee-A

Employee-A

 image.png

You can achieve this by creating new entity Attendance and make one to many associations between Employee and Attendance.

In attendance you can store daily attendance and number of Present day and number of absent day.

answered
0

Hello Raju,

 

Thanks for the quick response

The data presentation is as below

image.png

 

Question is, How to derive last row Total

 

Regards

Sudhir

 

answered
0

Hi Anurag,

 

Excellent. We have achieved the same. 

 

Thanks for your timely support.

 

Regards

Sudhir

answered