Applying global filters affect not only the main report table but any generated distribution graphs or pivot tables as well.
Applying local filters affect only the distribution graphs or pivot tables that the filter is entered from.
Often times, the data you want to analyze might be split over multiple files. In order to analyze all the data as a cohesive data set, you must first combine the files. In PivotBillions, you can combine data files that have the same schema or data structure by following these steps.
When you have different types of data files that are connected through common keys, PivotBillions allows you to Join these files in a left join fashion. This is very useful if you want to integrate a lookup table to your primary data set. In the following example, we will combine the two sample New York taxi data files and then join the taxi zone lookup table file located here to the combined data set.
To Join data, follow these steps: