Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community,
I am trying to find the average number of days it takes employees to reach a certain sales milestone. This is calculated by the number of days from the date an individual was trained to the date that milestone was reached. For this I have three fields: TrainedOnDate, MilestoneType, and MilestoneDate. My expression is as follows
avg(NetWorkDays(TrainedOnDate, day({$<MilestoneType={6}>} MilestoneDate)))/20
In order for me to find the average time it takes to reach a certain milestone type I have to use set analysis on the MilestoneDate field but that is where I am getting the error of "expecting a ')' ". Though I have check to make sure my parenthesis are indeed correct.
Any thoughts on this would be appreciated.
Anthony
Thank you Thiago! The second expression worked after appending an ending parenthesis. The final expression should look like:
Avg(Aggr(NetWorkDays(TrainedOnDate, Only({$<MilestoneType={6}>} MilestoneDate)),MilestoneType))/20
Try this
avg(NetWorkDays(TrainedOnDate,day( Only( {< MilestoneType={6}>} MilestoneDate))))/20
This brings up the error "Nested aggregation not allowed"
You should try something like this:
Avg(total NetWorkDays(TrainedOnDate, Only({$<MilestoneType={6}>} MilestoneDate))/20
Or
Avg(Aggr(NetWorkDays(TrainedOnDate, Only({$<MilestoneType={6}>} MilestoneDate),MilestoneType))/20
Thank you Thiago! The second expression worked after appending an ending parenthesis. The final expression should look like:
Avg(Aggr(NetWorkDays(TrainedOnDate, Only({$<MilestoneType={6}>} MilestoneDate)),MilestoneType))/20
Sound's good! Glad to help you