Hi, I’ve been trying to add calculated field to determine Resource Type based on following criteria: ifelse({Level}=‘6’ AND CountDirects >=‘5’,‘Manager’,‘Individual’). However, the approach I’ve currently taken adds CountDirects as countover ({Employee},[{Supervisor}],PRE_AGG) - i.e. it will show su…

Hi @Marianne_Parsik Direct Query Datasets DO allow joins. Is it locked maybe due to RLS? As an author another option is to create a child dataset, and in that one create the join above to get the analysis you looking for. Will that work? thanks! Ramon Lopez

Calculated Measures Help

Question & Answer

Kristin May 25, 2023, 6:26pm 2

Hi, @Marianne_Parsik

Wanted to let you know that we have this live Q&A today at 12 PM PDT. Feel free to join if you have any interest in talking through this or any other question real-time with one of our Solution Architects today.

cc: @Asem