I am new to Tableau and am using the Desktop Personal Edition and connecting live to Excel files. In this first visualization (twbx & Excel attached), I am trying to trend training data by month, department and team. The intent is to provide monthly and cumulative values with drill down from overall monthly value to department and team using the associated filters.
Excel Tab Calculations provides calculations in Excel using pivot and desired graph. Excel Tabs Training Data and Resource Data contain the data.
1) How do I get resource summary with a distinct count of resources?
2) Calculation Training Days Per Resources has resource count hard-coded. How can the resource count be calculated automatically using a formula based on the filter selections - Department, D-ID?
Your guidance is appreciated.