Hi,
I have a defined KPI in my knowledge model to calculate the median throughput time for my process:

 MEDIAN (CALC_THROUGHPUT (
    CASE_START
    TO
    CASE_END ,
    REMAP_TIMESTAMPS (
      "CONSUMER_APR_ACTIVITY_TABLE"."EVENT_DATE" ,
      DAYS
    )
  ))

I’d like to be able to compare median throughput times for all cases and only for cases which include a certain activity (for example: PENDING). I’d like to use either a table or a bar chart for this comparison.

What would be the best way to achieve that, considering that table filters apply on all columns? Can I introduce another KPI which will determine the median for cases which include PENDING only? If yes, how can I do that?
I look forward to receiving advice. Thanks.

Kind regards,

Vladimir