Hi @khkr999 -
The PoP functions in QuickSight require aggregated metrics - see the blog post to walk thru multiple use cases. If you have other requirements due to the way effectiveness is calculated, please share more details.
Best Regards,
Kellie