6 Replies Latest reply on Mar 14, 2016 11:59 AM by Manon V

    Average calculation based on period with months with no data

    Manon V

      The dates in my spreadsheet are anywhere from October 2014 to February 2016 (range of 17 months).   There is no data for July and August 2015.

       

      When I build my bar chart graph, July and August 2015 are showing in it but Tableau calculate the average based on the months that have data (so 15 months instead of 17).  If I did 82 / 17, my average would be 4.8, which is what my clients wants to see.

       

      Is there a way to work around this?

       

      Graph is attached.