Hi Nick, try wrapping AVG around entire CASE statement.
Thank you for the response, could you please show me how to create a custom filter in a Create Calculated Field instead of using the Filters field manually.
THEN [Role] = ("Design") //// Role is the Dimension I need to filter through, there are 8 options
I apologize for my lack of syntactical knowledge within Tableau.
Hi. Could you attach the workbook with sample data?