1 Reply Latest reply on Jan 14, 2020 12:39 PM by Ken Flerlage

    Average Data Based on Other Criteria

    robert.binney.1

      I'm sure this is simple.

       

      I'm pretty green with Tableau. I have a Likert-style survey ("1- Strongly Disagree <=> 7- Strongly Agree") and built a vizi that shows colored bars for strength of response (like described here).

       

      I added a pill that averages the responses. I would actually like TWO pills, one that averages the variable "Response" based on "Job Category = 2" and the other based on "Job Category=5" ("Job Category" is a dimension in my data).

       

      How do I do that? I presume it's a calculated field, but I can't crack it. Explain it to me like I'm an eight year old.

       

      Thanks!

       

      Gantt.jpg

        • 1. Re: Average Data Based on Other Criteria
          Ken Flerlage

          You'll have to create some new measures. For example:

           

          IF [Job Category] = 2 THEN

               [Response]

          END

           

          Then you'd average that. Then do the same for job category 5. But, depending on the structure of your data, this could complicate the creation of the chart. Any chance you could provide a sample workbook so we could take a closer look?