Count the number of records in a report

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I wish to build a bar chart where I can see the percentage of records per employee divided by total number of records in this report. X-axis is employee names, and Y-axis is percentage of records.

For an example, I have 2 employees with let's say A has 20 records, and B has 80 records. 

Total : 100 records

I want this chart to show 20% for A and 80% B. How can I build a formula to do this? I use count function for number of individual records, but did not know what to use to count the total number of rows in this report.
Photo of Ja

Ja

  • 0 Points

Posted 2 years ago

  • 0
  • 1
I suggest a pie chart as it will do % automatically.