creating a tableau pie chart with no measures data

Question

Every year, we undertake a system evaluation, which I have a table for (as shown in the image below). There are only three potential results for the evaluation, which consists of a sequence of four questions (or "attributes" as we call them).

I'd want to use Tableau to make the system a filter (which is simple to accomplish) and create a pie chart for each characteristic. I'm not recording any measurements.

Any ideas on how to go about it?

Thanks.

Answer 1

It's not difficult once you understand the power of LOD calculations in Tableau. Walkthrough-

Step-1 Create LOD calculated field for each Attribute as, Attri_1_Measure

{Fixed [Status of Attribute 1] : COUNT (sheet_name)}

Step-2 Add Attri_1_Measure to angle, size and text measures, Status_of_attri1 to text and color. You'll get your desired view.

Step-3 Add System to filters, right click and add filters to context (very important step).

These procedures can be repeated for each attribute.

Note: In tableau 2020, there is no measure for number of records, but there is a count measure for sheet/data table. Best wishes.