1 Reply Latest reply on Dec 6, 2013 11:34 PM by Prashant Sharma

    How can I keep a proportional count of a number over a period of time?

    Tim Roche

      I'm very new to Tableau, so bear with me. So here's my problem:

       

      Currently, there is a metric that we have that keeps a "score" of how well someone does that day. A good score is around 100. In Tableau, how can I find one's score based on days worked? For example, if someone had a 100, 75, and 90 then their score is 88.3.

       

      Here's how I see it in my head:

       

      [Day1/(DaysinMonth)] + [Day2/(DaysinMonth)] + etc..