2 Replies Latest reply on Oct 17, 2013 11:14 AM by mark bologna

    Averages not Calculating as Expected

    mark bologna

      I have an Excel spreadsheet as my data source where we input accuracy per employee per month.  Accuracy is calculated in the spreadsheet as follows: 1-( in error/ issues).  In Tableau I want to be able to display the accuracy rate per employee for any given month as well as their year-to-date cumulative accuracy.  I wrote a formula in Tableau called 'Issue Based Accuracy', but the result of the calculation is not correct if the time period is greater than one month.

       

      I read several other posts on similar topics, and think the solution is to use a table calculaiton, but could not make the jump from other examples to mine.

       

      Thanks,

      Mark