Supose that I have a Sales cube. I have different countries. I have a dahsboard filtered by country, so this dashbard shows all data about a country selected by user using dashboard filter. But now, I need to show an indicator with the total amount of sales as primary metric, and as secondary, the AVG of total amount sales for all countries. But, due to the widget filter configuration, affected by dashboard filters, I'm unable to calculate the AVG for all countries inside the same widget. Filtering is setting just one country, not all when doing the AVG(Country, SUM(Sales)) -just the same as primary metric, SUM(Sales)-
How can I achieve this using Sisense indicator?
Thanks in advance!
Please sign in to leave a comment.