2 Replies Latest reply on Sep 19, 2016 2:42 PM by Luis de la Torre

    Calculating number of time periods when a quantity is above a threshold

    Luis de la Torre

      I'm running Tableau 9.0.2.

       

      I have data of this form: Machine Quantity DateProcessed

       

      and I'd like to calculate by machine, the number of weeks in which the total quantity processed is above a threshold. An image of what I want is below. The top sheet shows values over time, with orange indicating that the value in that week is above the threshold. The bottom sheet shows the data I would like to show. I faked this sheet by creating a second data source that has the values I want, to illustrate clearly what I'm trying to do.

       

      I'm assuming that this can be done with some sort of level of detail calculation, but I'm confused on how to do this.

       

      I'm attaching a packaged workbook.

       

      Dash.png