Hello,
I have an issue and I am not sure it is a bug or a misconfiguration on my side.
I have the dataset gd_lease_agreements and a dataset gd_lease_agreement_extra which has a foreign key lease_agreement_id pointing to gd_lease_agreements (see screenshot).
Each row (representing an agreement) in the dataset gd_lease_agreements has a guarantee_amount fact. The dataset gd_lease_agreement_extra is some extra information for an agreement.
To display the count of agreements in a specific state, and the corresponding sum of guarantee_amount, I created a headline insight which will display X metric which is the count of gd_lease_agreements, and Y metric which is the sum of guarantee_amount.
The problem I have is that in my dashboard I have a filter based on an attribute in the dataset gd_lease_agreement_extra (
financial_status_fr
). When I keep only some value in this filter, the X metric of the highlight is filtered, but the Y metric is not.
Please see the screenshots for better clarity.