7 Replies Latest reply on Aug 7, 2019 11:01 AM by Hari Ankem

    Dynamic Text breakdown of a visualization

    Christopher Teeple

      Hey all,

      I would like to be able to update text to provide a breakdown of a visualization.

      For a simple case, let's say we are tracking sales data each day by three companies. Each company has its own employee list with sales data, and a bar graph represents the summation of sales, (three bars, one for each company).

      How can I display this in text? I tried creating a separate sheet with the metrics I wish to include in the text, but tableau will sum all of Company A, B, and C together. I wish to display Sum [Company A], Sum [Company B], and Sum[Company C] separate. Is there a way to filter the data inside a calculated field so I can create three calculations (SumA...SumB... etc.) without restructuring data?

       

      Thanks in advance for the advice!