1 Reply Latest reply on Feb 10, 2015 12:14 PM by Americo Guazzelli

    Using last row in table calc to generate chart : Help!

    Omar Shaker

      Hey guys

       

      I managed to calculate the running total for each category based on the number of records (1,2 or 3).

       

      I am trying to use my 3 running totals, to color code a bar that shows the total number of employees (distinct IDs)


      I want use these totals to create a pie chart or a stratified bar chart that shows total number of employees then uses my 3 calculations to color that bar into 3 different colors.

       

      Problem is I can only use the one calc as a color detail,

       

      Is there a way for me to tell tableau to use just my last row to generate a chart?

       

      Attached is a screenshot and the workbook