Hello @Ganga, since we are continuing from a previous topic, I will close out the last question and we can continue from here. Initially, I will say, creating a demo version of this analysis in Quick Sight Arena will make it a lot easier for us to debug the issues you are facing.
As for the aggregation error you are facing, are your hires and terms fields also calculated fields? If so, can you please share those with me as well?