3 Replies Latest reply on Sep 20, 2019 11:19 AM by Utkarsh Agrawal

    Average Number of Records

    Utkarsh Agrawal



      I am having a use case where I have to find average of number of records but when I do it in measure calculations it comes to be 1 which should not be the case.


      I have two columns Arrival Date (DateTime type) and Emp ID. I am trying to create a view where I can add a column next to the Grand Total column which basically shows average arrivals per day (i.e. total arrivals on Sunday/number of Sundays for given date range in filter). Please suggest a formula to help me with this. Thanks!