Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
Hope you are doing great.
Please can any one help on below set expression.
Scenario:
There is 2KPI's. If KPI-1 % <=80 and KPI-2% <=80%. Here i want to show the store for review.
Condition for NoReview: KPI-1 should be <20 and KPI-2>80
Condition for Review: KPI-1 should be >=20 and KPI-2<=80
Example:
-> KPI-1- 28 (Greater than 20) it should be reviewed even KPI-2 greater than 80.
-> KPI-1 - 19 and KPI-2 81, NoReview. Because these two are satisfying the condition.
-> KPI-1 - 10 and KPI-2 - 75 . It should be Review. because KPI-2 less than 80. Even KPI-1 <20.
Here i want to show the count for review in text object.
count is 3. 3 should be in text object.
I tried with below.But its not working.
=count({<KPI1={">20"},KPI2={"<80"}>})>} DISTINCT Store)
Thanks in advance!!
You can try this option:
Count({<KPI1={">=20"}>+<KPI2={"<=80"}>} DISTINCT Store)
Try this
=count({<KPI1={">20"},KPI2={"<80"}>} DISTINCT Store)
You can try this option:
Count({<KPI1={">=20"}>+<KPI2={"<=80"}>} DISTINCT Store)
Thanks for your great support Joseph,
But it's showing all the stores, not following the condition.
joseph.morales's expression seems to be working for me
Thanks Joseph,
Am extremely sorry. It was my script mistake. This is the perfect solution for my query.
Many thanks for your great help.