11 Replies Latest reply on Oct 11, 2017 4:11 PM by Hari Ankem

    Calculating Mean and Median from "Number of Rows"

    Mustafa Mushtaq

      Hi everyone!


      I recently found out about this forum and thought I'd ask a question regarding some trouble I've been having.


      I have an excel file with around 30,000 rows of data, starting from 7/1/2012 to 10/8/2017. Each data entry includes an "arrival date&time" field, which has a date and time inside. I am trying to visually display the mean and median by weekday and by hour of the day, depending on a filter that I have created that corresponds to the fiscal year. Now, when I try to do that, I just get a bunch of 1's, and not the actual mean and median per day and hour. Does anyone know why this is happening and how to possibly remedy this?


      Thanks in advance!