Our company recently implemented Tableau Software for our reporting analysis purpose.
At the moment I am facing a few problems that I cannot seem to resolved.
1. We have a MS SQL database with over 10k Customers, some are active and some are inactive. What I want to do is to show only the Active Customer together with those Customers who have purchased from us before. e.g. Customer purchase an item in April however went out of business in May so we put him into the inactive status, however when i generate sales report i want this customer to show up in the April data list.
2. How to use Google API without using Zip Code?
3. What would be the correct way to chart all Active Customer with purchase less than $10k for example?