Dropdown in Workspace Panel not filtering Metric as expected In a project, I use a dropdown filter of Product Categories to filter metrics in a table such as Carts, Orders, Cart Rate, etc.
However, when filtering by category in the panel, the Cart Rate (Carts/Unique Visitors) seems inaccurate from what I'm expecting. How can I create a formula that considers the selected category in the panel dropdown and provides an accurate Cart Rate for that specific product category?
I can manually create a custom metric that successfully returns the Cart Rate for a specific product category and have it return the "correct" value (somewhere about 2.5%), but the problem occurs when I try and use a panel dropdown to filter my table (it then returns about 20%). I know I could just create many custom metrics based on my categories, but I'd like to give my users the ability to see many metrics by product category in the same table by using the panel filter. Examples are Cart Rate, Checkout Rate, Order Conversion Rate, Abandoned Cart Rate, etc.
Thanks in ad
