7 Replies Latest reply on Aug 23, 2017 7:14 AM by Shinichiro Murakami

    calculated field for Row level Filtering

    Akshita Jain

      Hi, I have call center data where Agents are mapped with multiple metrics. For example, A1 is mapped with M1, M2, M3 and M4  and A2 is mapped with M2, M5 and M6 etc. Now my requirement is to compare only relevant metrics among agents. For this I have created a view (as attached) . Here all metrics displayed across columns irrespective of whether they are relevant or not. Now I want to customize the view where only relevant metrics appears. So for example if I want to compare A1 with other Agents A2, A3, A4 then this view should show only metrics M1, M2, M3 and M4. Please note that, agent that would be compared with other agents will be decided dynamically. Please help as this is quite urgent.

       

      I tried using set and calculated field which use contain function but it doesn't work.

       

      Look forward to your response.