Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys. I hope you can help with this. So, I want to identify how many organization that has no meet with a priority of 3 only. I want to display it on the KPI. Please see the attached file. That's the sample. Thank you.
Hi, with this script:
LOAD orgs,
priority
FROM
[.\sample.xlsx]
(ooxml, embedded labels, table is orgs);
LOAD orgs,
meet
FROM
[.\sample.xlsx]
(ooxml, embedded labels, table is meet);
This expression may work: =Count({<priority={3}>-<meet={"*"}>} orgs)
Thank you, sir! It solved my problem. You're the best! 😁