When you set the filter up, towards the bottom of the filter UI, you can select which charts/widgets the filter applies too. I would just unselect the one that you want to cover all customers, and that should work
Create 2 KPI widgets, each showing the average turnover for all customers. Add a filter for customer and apply this filter to any one of the widget. now this widget which gets affected by the filter will show the average turnover for the selected customer and the other widget will show average turnover for all customers.
I am not sure about a workaround to compare both in a single widget
At the time being, our team is actively researching to ensure the best User Experience for this type of calculation so I cannot promise you the exact timeline yet.
This should be included in the AMQL Expression.
Just wondering other than “Compare “filtered” metric versus global average”, are there any other analytics use cases that are on your top priority at the moment?