3 Replies Latest reply on Feb 9, 2018 11:14 AM by ShivaRam Chennapragada

    Custom Parameter and Calculations based on Filters

    Nick Colavita

      Tableau Community,

       

      Front End Developer here new to Tableau.

       

      Quick question

       

      I have a Hours measure I need to Average out per employee Role (Dimension)

       

      I'd like to make a custom parameter with a drop down and a Case statement (so its easy to filter through each role and see the data change automatically)

       

      I am having a hard time combining the AVG method with filtering out per role (ex. "Designer" "Developer" "QA")

      What I need to do is

       

      CASE [Average Per Team]

      WHEN "Parameter"

      THEN AVG([Hours]) per Role //// this is where I'm stuck

      ...(do this for each role)

      END

       

      Thanks