3 Replies Latest reply on Dec 2, 2013 2:13 PM by Tracy Rodgers

    calculate by last date of a dimension field

    Jimmy Figueroa

      Hi folks

       

      I have this table in tableau:

      Screen Shot 2013-11-19 at 2.23.28 AM.png

      I need to aggregate the 'accepted' and 'not accepted' by the last 'fecha' iteration every 'procedimiento', but here is the catch: 'procedimiento' and 'fecha' are non-visual elements in the worksheet where these calculations need to appear.

      That means a sum of 2 accepted and 1 not accepted.

       

      I tried a calc field like this:

      Screen Shot 2013-11-19 at 2.26.57 AM.png

      I put 'Procedimiento' and 'Fecha' on the Marks shelf, made 'Sum of Accepted' compute by 'Fecha' and moved 'Sum of Accepted' to the filter shelf indicating 'non null values'.

       

      Problem is I get values of '1 1' instead of value '2' for my 'Sum of Accepted' in my worksheet, like this:

      Screen Shot 2013-11-19 at 2.30.18 AM.png

       

      Here is my tableau public workbook Workbook: calc by last date of a dimension field

       

      Thxs for any help

      Jimmy