Skip to main content
Question

Benchmarking in Views: How to link KPI Lists and Process Explorers to the selected fields

  • May 4, 2023
  • 1 reply
  • 32 views
R
Level 5
Forum|alt.badge.img+14

Hi. In views, when designing a benchmark tab, I want to link both the PE and KPI lists to the chosen dimension.

I select a dimension in a first dropdown (eg. Company Code) , then select the different company codes I'm trying to compare (in a different pair of dropdowns), but these components (Process Explorer, KPIs, etc..) do not update. In analysis I'd need to create a component filter, but how to proceed working on views?

    1 reply

    badrinath.nooka13
    Level 3
    Forum|alt.badge.img+14

    You need to add filter condition in the yaml editor of process explorer or kpi list of views to show only for selection in drop down.

     

    for example:

     

    filters:

      - pql: FILTER "${dd_variable ==

          'Company Code'?'case_table':dd_variable

          =='User'?'activity_table''}"."${dd_variable}"

          = '${process 1}'

     

    here company code is coming from case table, user is coming form activity table so when they select company code in main dropdown it will be updated in dd_variable and values related to company code are shoun in drop down 1 and this selection is stored in process 1 variable and using this we filter components.

     

    The above condition works lie a if else condition and it finally becomes something like FILTER 'case_table'.'Company code' = '00001'

     

    Hope this is clear, any doubds please comment

    Community Code of ConductAccessibility statement