2 Replies Latest reply on Oct 25, 2018 5:06 AM by leonardo.zanobetti

    Average of occurrences by hour of the day




      I have recently started to learn Tableau. I have not been able to find an answer to this question yet, thus I am posting it here.


      I have a dataset about crimes in Chicago from 1st January 2018 until mid-October. The dataset includes an ID for every crime committed, a description of the type of crime, and the date and the hour when it happened.

      Screen Shot 2018-10-25 at 11.59.24.png


      I would like to make a bar chart where each bar represents the average number of crimes committed at that hour throughout the period of my dataset. For instance, the first bar should present the average number of crimes committed between midnight and 00:59. I guess I need to make a calculated field, but any help on this would be great.


      For now, I only managed to make a bar chart that shows the total number of crimes committed throughout the day for the period included in my dataset (see picture).



      Screen Shot 2018-10-25 at 12.01.10.png


      I attached a copy of the workbook. I am working on a Mac 10.13.6 with Tableau 2018.2.2.


      Any help would be highly appreciated!


      Thank you very much.