I created a calculated field to determine the total sales value and total product sales value. I then applied these filters to two visualizations:
- A table showing a list of customer IDs
- A card visualization displaying the total customer count
When I apply a filter like “Sales > 500,” the table correctly shows only the customers with sales over 500. However, the card visualization still displays the total customer count, not the filtered count.
Interestingly, when I use filters based on non-calculated columns, both visualizations filter correctly. I’m trying to understand why the card visualization doesn’t reflect the filter when using calculated fields.
Can anyone help me why it is not working for card visualization?