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)