Skip to main content
Question

How to use OR in numerator and denominator while writing KPI in ratio format

  • October 21, 2021
  • 2 replies
  • 2 views

How to use OR in numerator and denominator while writing KPI in ratio format

2 replies

  • Level 8
  • October 22, 2021

Hi Chetana,

 

In the numerator you can include the OR without problem in the PQL statement.

For the denominatior I would set a Filter at the component level (Background filter) with the OR condition.

 

Hope it helps

Best

Javier


Forum|alt.badge.img+12

Hi Chetana,

 

I agree with what Javier said.

 

As a workaround you can also try creating a variable wherein you can write 'OR PQL' query and use that in your component.

 

It should work.