Sean Barry
09/08/2023, 4:05 PMFrancisco Antunes
09/08/2023, 4:33 PMSean Barry
09/08/2023, 4:36 PMFrancisco Antunes
09/08/2023, 4:58 PMMichal Hauzírek
09/08/2023, 5:14 PMSELECT SUM(amount) WHERE Sales Pipeline Status = 'Sold'
(or similar, I am not sure about your exact data model)
• then use this same metric both for the healdine and the detail
This way the filter will be part of the metric and will be used anywhere you use it.
This way you can also combine within the same chart the metric for “sold” with another metric which does not use the “sold” filter if you need to.Sean Barry
09/08/2023, 5:19 PMSean Barry
09/08/2023, 5:20 PMSean Barry
09/08/2023, 5:21 PM