Bottom 10 Visual Showing Customers from Other Years Despite SelectedYear Parameter Logic in QuickSight

Q&A
, ,
8

Hi @WLS-Luis ,

I’ve shared the analysis link created in ARENA Sandbox with the sample customer data, and it reflects the same issue explained earlier.

Customers who have no sales in the selected year are getting assigned a value of 0, which makes them appear in the Bottom 10. Since the report must show both current-year and prior-year sales, we cannot directly filter by year, and that’s why these zero-sale customers are still included.

Bottom 10 Visual Showing Customers from Other Years Despite SelectedYear Parameter Logic in QuickSight

Amazon Arena Sandbox: An embedded instance of the Quick Sight capability, within the Amazon Quick Community - What’s New - Amazon Quick Community

Thanks,
Vishal