Skip to main content
Solved

Filter for the KPIs in a table component

  • May 21, 2024
  • 3 replies
  • 25 views

deeksha.r12
Level 7
Forum|alt.badge.img

Hello Everyone,

Can we apply a filter only for certain KPIs in a table component. Different filters for different KPIs.

Best answer by deeksha.r12

Hi Rodrigo,

Thank you for the solution, I did try something similar to this.

3 replies

Forum|alt.badge.img+6

No, there is no way to apply a filter to a specific section of a component (such a column that displays a KPI), you can only do it to full components (like a table).

 

If I may suggest an alternative, you might be able to modify the KPI to include the filter within it to avoid the need of the filter. For instance, lets say that your KPI is counting the number of cases CUNT_TABLE("EKPO") and you want to filter only those cases whose EBELN starts with a 1. You can change the KPI by embedding it in a CASE WHEN such as:

 

SUM(CASE WHEN

"EKPO"."EBELN" LIKE '1%'

THEN 1

ELSE 0

END)

 

Could that trick be used to solve your problem? Otherwise, please reach out again and maybe we can find a common solution to your specific problem.

Thank you!

Hope it helps,

Rodrigo


deeksha.r12
Level 7
Forum|alt.badge.img
  • Author
  • Level 7
  • Answer
  • May 27, 2024

Hi Rodrigo,

Thank you for the solution, I did try something similar to this.


Forum|alt.badge.img+6

Amazing, I am glad it helped