My problem that I am facing in Tableau is with 2 different data sources. I have an excel sheet which has two tabs, one for Product info and the other for Client info.
I have to filter the Product which is further classified as different programs. A product can have multiple programs. Then, I count the values in my second tab with the date comparison.
From the second tab, I have to count the number of records basis on the date comparison but there are some problems. The calculation that I have created is only working for the dates that are present in both the tabs but I want to list the remaining values as well in their specified date ranges.
I will post the excel file shortly as the data is not with me now.