Average Number of submission
I met difficulties to build a report about average submission.
I would like to have the average number of submission per interview step and per Job Field tree.
I succeded to have the average, when I go to result and put aggregation rule (AVG) on my column "Nombre de candidat moyen".
My issue is, I do not want to have the requisition Identifier column and I do not want the detail per Requisition identifier. I would like to have directly "4,00" next to "Entretien Manager (N+1)" for example (please find my screenshot attached).
I tried to work with the formula of my column "Nombre de candidat moyen". The actual formula is COUNT("Submission General Info"."Submission Identifier") I also tried with the candidate fact proposed by Oracle but it is the same result. I tried with these fields, these formula :