How insert filter in edit column formula behaves?
We are currently running some tests in OTBI analysis and we would like to know how some formulas work.
We have created a custom matrix analysis in which we are using the Allocated On-boarding Checklist column. From this column we want by editing the formula to insert a filter where the column Category will be equal to Enterprise On-boarding.
This is the Formula: FILTER(COUNT( "Allocated Checklist"."Person Number") USING (DESCRIPTOR_IDOF("Workforce Management - Checklist Real Time"."Allocated Checklist"."Category") = 'ORA_ONB_ENT_ONBOARDING_STEP'))
Although this does not work in results and only works if we apply a filter in Category column by each self.