Hi,
I am looking to add fields to a couple of the tables below. These three tables are in a stacked bar chart, so when I click on a filter for "ELT Member Name" or "Home Department Description", I'd like for it to filter all the way through instead of just for an individual table.
The tables are connected on the Date field. ADP table has the "Home Department Description" field that I want to add to the other two tables. Jira and Lever tables have "ELT Member Name" and "ELT Member", using either of these works for a filter.
Ideally, I would be able to click on ELT Member which then filters Home Department Description to show only departments correlating with that Member (for all three tables). I tried accomplishing this with an ApplyMAP, but could not figure it out.
Tables below:
ADP:
LOAD
"Position ID",
"Payroll Name",
"Job Title Description",
"Reports To Name",
"Reports To Position ID",
"Annual Salary",
"Base Currency Code",
Location,
"Home Department Code",
"Home Department Description",
"Worker Category Description","Hire Date",
"Termination Date",
"Rehire Date",
"Previous Termination Date",
if(not exists([Termination Date]), '02/01/2022', [Termination Date]) as "End Date"
Resident ADPTable1;
Drop Table ADPTable1;
ADP2:
Load
"Position ID",
MonthStart("Hire Date" + IterNo() -1) as Date
Resident ADP
While MonthStart("Hire Date" + IterNo() -1) < "End Date";
///////
Lever:
LOAD
reqId,
"Quarter of Offer Accepted",
"Quarter of Anticipated Start",
trim("Finance Hire Code") as "Finance Hire Code",
"Requisition Code",
"Detailed Req Status",
"Requisition Name",
"Requisition Hiring Manager",
"Requisition Owner Name",
req_region,
"Candidate Name / Req Location",
"ELT Member",
"Requisition Team",
"Current Workflow Status",
headcount_type,
"Requisition Commitment",
"Day of Open / Offer Accept Date",
"Day of Forecast / Actual Start Date" as Date,
"Days Open",
"Day of Requisition Created",
////////
Jira:
Load
"Home Department Code" ,
"Summary Dept",
Key,
Supervisor,
"ELT Member Name",
"Headcount Request Type",
"Employment Type",
"Position Type",
Summary,
"Hourly or Salary",
"Proposed Annual Salary or Hourly Rate:",
"Proposed Term Date (Contractors and Interns only)",
"Proposed Region(s):",
"Primary Recruiter",
"Base Salary Target",
"Sales Pay Mix",
trim("Finance Hire Code") as "Finance Hire Code2",
"Department (Hiring)",
Reporter,
Status,
"Forecast Start Date:" as Date,
"Budgeted Start Date:"
Where Not Exists("Finance Hire Code", "Finance Hire Code");
