3 Replies Latest reply on May 23, 2013 5:05 PM by Vinodh P

    Average of percentage for categories

    Vinodh P

      I have a percentage-based stacked bar chart with the date on the x-axis and % of total number of records on the y-axis. I have "Action_Type" category as a color mark, so the chart shows broken down by the "Action_Type" categories. I would like to show the average of percentage for the categories (2 categories as shown in the chart) as a reference line. I already have a band reference line as shown, but those are constant numbers I have setup for other purposes.

       

      Can you please let me know how I can add a reference line for each category that shows the average of the percentage for that category, instead of for total ?

       

      Thanks.

       

      Tableau_Chart.png